Happy President's Day

This weekend is, in the United States, a holiday weekend. That's because Monday is a federal holiday. Historically, it started as a day to remember the birthday of George Washington, our first president. In the last few decades, however, it has come to be known as President's Day in many states, and is a day to celebrate both Washington and Lincoln's birthdays.

I hope that you find this weekend enjoyable and a time to enjoy some time with your family. (I also hope you enjoy the tips in this week's issue of the newsletter.)

—Allen
     

ExcelTips (menu) for 18 February 2017

Powerful spreadsheets
Last Saved Date in a Footer

When printing out a worksheet, you may want Excel to include, in the footer, the date the data was last saved. There is no easy way to include that information without using a macro. Here's how you can get the output you need.

Read this tip »

 
Graphics
Specifying an Order for Drawing Objects

Drawing objects can be layered over each other in almost any manner you desire. If you want to change the order in which those drawing objects are layered, you'll want to use the techniques in this tip.

Read this tip »

 
Formatting Made Powerful

Discover one of the foundational building blocks of Excel. Custom formats are the basis for all cell-level formatting in Excel, and you can master their use. Display your data exactly and precisely as you want.

 
Editing
Deleting All Names but a Few

Want to get rid of most of the names defined in your workbook? You can either delete them one by one or use the handy macro described in this tip.

Read this tip »

 
Formulas
Replacing Dashes with Periods

Replacing one character in a text value with another character is easy. All you need to do is use the SUBSTITUTE function, as illustrated in this tip.

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