Cool and Warm, In the Same Day

In our corner of the world right now, we are experiencing cool (some would say "chilly") nights and warm days. This makes for great weather for outdoor activities and working in the yard. I know that I've been enjoying it that way, at least.

I hope that your September is going well and that you enjoy the tips in this week's issue of the newsletter.

—Allen
     

ExcelTips (menu) for 7 September 2024

Spelling
Spell-Checking in a Protected Worksheet

When you protect a worksheet, you can't use some tools, including the spell-checker. If you want to use it, you must unprotect the worksheet, run the check, and then protect it again. All of this can be done quite quickly by using the macros discussed in this tip.

Read this tip »

 
Cell formatting
Adjusting Cell Margins for More White Space

Is the information in your cells too jammed up? Here are some ways you can add some white space around that information so it is more readable.

Read this tip »

 
ExcelTips at Your Fingertips

Support ExcelTips and obtain a valuable resource—your own copies of the ExcelTips archives. Each archive contains all the tips for a calendar year; often over 400 pages of detailed info on how to better use Excel. Learn more about Excel today!

 
Powerful spreadsheets
Weighted Averages in a PivotTable

PivotTables are used to boil down huge data sets into something you can more easily understand. They are very good simple aggregations, such as sums, counts, and averages. They can't do weighted averages, however. That doesn't mean you are out of luck; you can still calculate weighted averages using the ideas in this tip.

Read this tip »

 
Powerful spreadsheets
Saving Non-Existent Changes

Open a workbook, look at the data, start to close the workbook, and you are asked if you want to save your changes. What gives? You made no changes, right? Here's why you see that message even if you made no overt changes to your data.

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