Spread the Word

Do you know people who use Excel? Don't you think they could benefit by a free subscription to ExcelTips? Invite your friends, colleagues, and family members to join our family of subscribers. For instance, you may be part of a forum or discussion list where many of the members use Excel. Why not let them know about this resource? Simply direct them to the ExcelTips website (excel.tips.net). At the right side of any page on the site you can find a sign-up form for the newsletter.

Thanks, and I hope you have a great weekend!

—Allen
     

ExcelTips (menu) for 22 July 2017
Powerful spreadsheets
Setting Page Margins

When getting ready to print your worksheet, you may want to take a moment to check what margins Excel will use on the printout. The program makes it easy to modify the margins of your printed page.

Read this tip »

 
Graphics
Creating a Log/Log Chart

If you need to create a chart that uses logarithmic values on both axes, it can be confusing how to get what you want. This tip explains which of the chart types in Excel is best suited for the type of chart you need.

Read this tip »

 
Is It Worth a Thousand Words?

Tired of looking at boring numbers? Add the persuasive power of charts and graphics to your worksheets. Excel's tools can help you present your data in a more understandable, accessible manner. Find out why a picture is worth a thousand words.

 
Dates and times
How Excel Stores Dates and Times

Excel stores dates and times internally using what is called a serial number. This tip explains how that serial number is derived.

Read this tip »

 
Tools
Turning Off Track Changes without Unsharing

The Track Changes tool in Excel can be helpful, but it can also be aggravating because it doesn't allow you to use it on a shared workbook. This tip examines the precise interaction between Track Changes and workbook sharing.

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