Back in Wyoming

This past week I've been down in Arizona, visiting family, doing some video filming, and generally enjoying the warm weather.

I drove back home on Friday, however, and now I'm back into the early-season cold that comes with Wyoming life. (It's not unusual to have overnight snow skiffs right now. I know that will develop into full-blown storms eventually.)

Even with the cold, it's good to be back home. Now I just have to get caught up wtih my backlog of work and make headway on several projects I'm working on right now!

I hope your weekend goes well and that you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (menu) for 21 October 2017

Comments
Moving Comment Background Pictures to Cells

When formatting comments, you can use a graphic as a background for the comment box. If you later want to move this graphic into the worksheet itself, the task can be difficult. The macro presented in this tip makes quick work of the task, however.

Read this tip »

 
Powerful spreadsheets
Can't Update Excel 2007 PivotTables in Excel 2003

If you create a PivotTable in Excel 2007, you may have problems editing or updating that PivotTable in Excel 2003. The only way around the problem is to not use such PivotTables in the earlier version of the program.

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.

 
Borders and shading
Drawing Borders

Adding borders around cells is a common formatting task. You can make the task more intuitive by actually drawing the borders using the mouse.

Read this tip »

 
Powerful spreadsheets
Using Subtotals and Totals

You can insert subtotals and totals in your worksheets by using either a formula or specialized tools. This tip explains how to do both.

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