ExcelTips (menu) for 7 September 2024

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 »

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!

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 »

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 »