The Hot Days of Summer

Are you enjoying summer? (I hope so.) Around here the days are about as long as they will get, the days are hot, and the evenings are cool. I'm enjoying all the outdoor time as I try to get caught up on projects around the yard and house.

I hope that you enjoy the tips this week.

—Allen
     

ExcelTips (menu) for 24 June 2017

Workbooks
Updating Links in Copied Files

When you copy workbooks that contain links, you may be at a loss as to how to update those links. There are a couple of ways you can approach the task, as discussed in this tip.

Read this tip »

 
Cell formatting
Turning Off Names

You can use some of the tools in Excel to convert cell references in formulas into names. Converting back (from names into cell references) is not so easy, requiring manually editing the formulas.

Read this tip »

 
PivotTables Make You Feel Faint?

Do you get weak in the knees when asked to deal with huge amounts of data? Forget feeling faint ever again when you are asked to deal with PivotTables. Learn much more than the basics with PivotTables for the Faint of Heart, now available in three great versions.

 
Powerful spreadsheets
Maintaining the Active Cell

Move from one worksheet to another, and Excel selects whatever cell was last used in the worksheet you are selecting. If you don't want this behavior (you want to have the same cell selected on the new worksheet as on the old), then you can apply the techniques in this tip.

Read this tip »

 
Powerful spreadsheets
Printing a Draft Watermark

Adding a watermark to the background of a printout can be challenging. This tip explains the different ways you can implement your own watermarking techniques.

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