When formatting a chart, you select elements and then change the properties of those elements until everything looks just the way you want. If you want to unselect a chart item—perhaps so you don't accidentally change it—here's a quick way to do it.
When you load data into Excel that was created in other programs, the formatting used for some types of data (such as dates) may not be understood by Excel. Here's how to convert the data to a format that can be used by the program as you expect.
If you have some cells merged in a worksheet, and you wrap text within that merged cell, Excel won't automatically resize the height of the row as it would with unmerged cells. This tip describes how you can work around this limitation.
When you make changes in a worksheet, Excel automatically recalculates everything that may be affected by that change. If your worksheet is complex or huge, having the program recalculate after every change can slow down data entry. Here's how to force Excel to only recalculate when you want to recalculate.
Page numbers in Excel printouts are typically simple counters, without much chance for embellishment. If you want to add leading zeros to your page numbers, the best solution is to use a macro to do your printing.
If you get an error when you try to use one of your custom views, it could be due to the protection you have applied to the worksheets. This tip explains why this may cause a problem and what you can do about it.
Got a bunch of worksheets and you want to save paper by printing multiple worksheets on a single piece of paper? There are several ways to approach the issue, and the one you choose will depend (to a degree) on the characteristics of the data you need to print.
One of the important configuration files for Excel is known as the XLB file. You should periodically make backups of this file, in order to protect the customizations you've performed on Excel's toolbars.
The process of combining string (text) values to make a new string is called concatenation. Excel provides the CONCATENATE function to accomplish the task, but there is an even easier way to join strings together.
If you ever try to edit a PivotTable and get an error that tells you that the "underlying data was not included," it can be frustrating. This tip looks at possible causes for this error and how you can solve the problem.
Text boxes are easy to add to a document and manually resize, as needed. If you want to resize the text box in a macro, however, the way to do it effectively may seem elusive. This tip explains how you can resize a text box to cover a desired range of cells.