Giving Thanks

In just about 5 days we, in the United States, will be celebrating Thanksgiving. We celebrate the day (next Thursday) with family, as we get together to enjoy a special meal and give thanks for our blessings.

As we approach the holiday, I hope you have the opportunity to reflect on the blessings you enjoy and, as appropriate, give thanks for them in your own way.

Have a great week!

—Allen
     

ExcelTips (ribbon) for 22 November 2014

Online and web
Pulling Apart a URL

Excel provides a good number of worksheet functions that can help you pick apart text strings in various ways. In this tip those functions are put to use to pull apart a URL into its component pieces.

Read this tip »

(Thanks to Mike Davies, Steve Aprahamian, Cliff Edwards, Martin Nicol, Jim Gerland, Michael Tardie, Lisa Ralon, Erik Obert, Andrew Gray, Andrija Vrcan, Bob Beechey, Nir Liberman, Jacques Raubenheimer, Nadine Claessens, Guy Goodwin, Andreas Hattestad, Jennifer Thomas, Barry Denning, Don Bruck, and Erik Berg for contributing to this tip.)

 
AutoFill
Turning Off AutoFill

AutoFill is a great editing tool that comes in particularly handy when you are first creating a worksheet. You may, at some point, want to turn off the feature. This tip shows how you can do this.

Read this tip »

 
Serious about Sorting?

Organize your data in the order that makes sense to you. Excel's sorting tools make it easy to get at the data you need. Get a firm grip on sorting today and your data management tasks will be easier than ever!

 
Editing
Copying Cells to Fill a Range

Excel provides two really helpful shortcuts you can use to fill a range of cells, either horizontally or vertically. These shortcuts will help make your data-entry tasks a breeze.

Read this tip »

 
Macros extend Excel
Swapping Two Strings

Strings are used quite frequently in macros. You may want to swap the contents of two string variables, and you can do so by using the three-line techniques introduced in this tip.

Read this tip »

 
     

Need More ExcelTips?

You are reading the free version of ExcelTips. There is another version you could be reading right now: ExcelTips Premium. This week ExcelTips Premium subscribers also learned about:

  • Counting Employees in Classes
  • Storing a User's Location before Running a Macro
  • Evaluating Formulas
  • Expiration Date for Excel Programs

Each weekly newsletter is in a professional PDF layout and presents double the tips (Premium subscribers see articles you won't in regular ExcelTips) with great, useful graphics. Plus, ExcelTips Premium subscribers get valuable money-saving benefits. For more information (including a sample issue), visit the Tips.Net store.

     

Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

 
Copying Dates a Year Into the Future

I have a column (column A) of dates in the year 2014. I want to copy that range of dates into another worksheet in the same workbook. I need to make the dates all the same, except for the year, which should be 2015. How do I do that?
—Juan Martinez (provide an answer for this Help Wanted question)

 
ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 794  •  Orem, UT  84059  •  801-607-2035