Show description

The question inevitably arises as to when it’s more efficient to edit a cell entry directly versus editing it on the Formula bar. For me, this decision depends upon the length of the cell entry and its position in the spreadsheet. When dealing with really long and complex formulas in a cell (like the one shown in Figure 6-4), editing them directly in the cell can end up obscuring the cells in the surrounding region to the right and below the cell, which is okay unless you need to refer to these cells in your edit.

Figure 5-3: Setting up a conditional format to blank out the display of error values in a range. As soon as you click OK, Excel replaces all the error values in the cell or cell range you selected with white, effectively blanking out their error value results without disturbing their formulas. If all you want to do is suppress the display of error values in a printout of the worksheet, you don’t have to go to all that trouble of first blanking out their display by setting up a conditional format.

To open this dialog box, click the Rearrange Commands button on the Commands tab of the Customize dialog box. • Figure 2-2: The Rearrange Commands dialog box makes it easy to add, delete, or reorder the options on Excel toolbars and menus. To customize a menu or toolbar in the Rearrange Commands dialog box, follow these steps: 1. If you’re customizing a pull-down menu, click the Menu Bar option button and then select the pull-down menu name in its drop-down list box. If you’re customizing a toolbar, click the Toolbar option button and then select the toolbar name in its drop-down list box.