Rushing About for Christmas

Christmas is fast approaching, and it always seems like there is more to do in order to get ready. We have family visiting today, and then more family coming this next week. Most of of our kids (2 out of 3) and their children will be with us for the "big day," and we are looking forward to it!

I hope your holiday season is going well and that you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (menu) for 16 December 2017

Printing
Setting Print Titles

Excel allows you to specify certain rows or columns that will be repeated on the pages of a printout. Here's how to set those titles so Excel knows what to do with them.

Read this tip »

 
Editing
Getting Help when Entering Functions

Need a quick memory jog when entering a worksheet function? Here's a shortcut that will be invaluable.

Read this tip »

 
Making Sense of Times and Dates

One of Excel's great strengths is its ability to work with huge amounts of raw data. Two of the most common types of data stored in Excel are times and dates. Working with these special data types is not as easy as it may first seem. Check out ExcelTips: Times and Dates and learn the secrets of working with your times and dates.

 
Powerful spreadsheets
Using a Different Footer on Secondary Pages

When printing a worksheet, you may want to have the footer different on the first page of your document than it is on subsequent pages. Here's a couple of ways you can get the desired changes.

Read this tip »

 
Editing
Getting Rid of Everything Except Numbers

Got some numbers and letters mixed up in the same cell? You may need to get rid of those letters so you are left with just the numbers. Here's some ways you can process that data just as you want.

Read this tip »

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 1187  •  Mountain View, WY  82939  •  307-200-0450