Customizing Excel

Tips, Tricks, and Answers

The following articles are available for the 'Customizing Excel' topic. Click the article's title (shown in bold) to see the associated article.

Adding a Little Animation to Your Life
One of the configuration options in Excel allows you to "spice up" the program's interface by adding animation to certain tasks. You can turn this feature on (or off) by using the Edit tab of the Options dialog box.

Changing Excel's Background Color
Excel doesn't provide a built-in means to change the standard background color of a worksheet. There are a few different ways you can work around this limitation, however. This tip discusses several methods to get just the color you want.

Changing Gridline Color
The gridlines used in a workbook are normally light black. You can modify the gridline color by following the steps in this tip.

Changing the Comment Font
The comment boxes font and color can be customized using this tip.

Colors and Fonts for Worksheet Tabs
If you want to change the color used for a worksheet tab, the change is only a click away. This tip examines how easy it is to make the changes you wan to your worksheet tabs.

Controlling Display of the Formula Bar
The Formula Bar is a regularly used feature in the Excel interface. You can, however, modify whether Excel displays the Formula Bar or not.

Controlling the Display of Toolbars
How to customize the view of the toolbars available in Excel.

Creating Superscript and Subscript Buttons
Want a quick way to apply superscript and subscript to selected text within a cell? This tip shows how the formatting can be done through a user form and a small set of macros.

Customizing Quick Access Toolbar Icons
The standard way to customize Excel is to add tools to the Quick Access toolbar. The program provides only a limited capability to change the icons used to represent those tools.

Cycling Through Colors
Excel includes quite a few tools that are not normally accessible through the various toolbars or (in Excel 2007) the ribbon. One such esoteric tool is one that allows you to quickly cycle through the colors that can be applied to a cell. This tip explains how to make this handy tool accessible.

Default Worksheet when Opening
When opening a workbook, you may want to make sure that a particular worksheet is always displayed first. The only way to ensure this is through the use of a macro, described here.

Defining and Using Custom Colors
Normally Excel allows you to work with a well-defined, but limited, palette of colors. If you want to change out some of the default colors for ones more to your liking, you can do so by using the steps outlined in this tip.

Easily Deploying Customizations
When you create a whole set of customizations for Excel, you may want to share them with others in your office or workgroup. This tip provides some guidance on how you can best do that.

Enlarging the Formula Bar
The Formula bar is used to display the formula that appears in a cell. You may want to modify how the Formula bar is displayed. Your modification options are limited, but you can always hide the Formula bar completely.

Setting the AutoRecover Directory
Excel, by default, periodically writes information to AutoRecover files that can help protect your data in case Excel is ended abnormally. You can specify where you want these AutoRecover files stored by using the information in this tip.

Specifying the Behavior of the Enter Key
When you press Enter while adding information to a worksheet, Excel normally drops to the next cell down in the column. You have complete control over what Excel really does after an Enter, as described in this tip.

Strange Excel Open Option
Once in a while strange wording can appear on Excel's menus. When it does, you might wonder why that wording is there. Here are a couple of ideas you can use when tracking down the cause of the unusual wording.

Turning on Placeholders
A large number of graphics in a worksheet can slow down Excel. One way to compensate is to turn on picture placeholders, an easy setting that displays placeholders instead of the actual graphics.

Understanding Manual Calculation
By default, Excel automatically recalculates your workbook after an edit or when you save your file. You can modify when Excel recalculates by applying the information in this tip.

 

More Information

The following are additional topics related to the subject of 'Customizing Excel'. A bracketed number after the topic indicates how many articles are related to that subject.