Page 213 - Excel 2013 All-in-One For Dummies

the formula that sums the values together. Excel offers just such a command on the Home tab in the form of the Delete button and its drop-down menu. When you choose Delete Cells from the Delete button’s drop-down menu
(or press Alt+HDD), a Delete dialog box appears, similar to the one shown in Figure 3-4. This dialog box lets you choose how you want the remaining cells to be shifted when the selected cell (or cells) is removed from the work- sheet.
Keep in mind that when you use the Delete Cells option, Excel zaps every- thing, including the contents, formatting, and any and all attached com- ments. Don’t forget about the Undo button on the Quick Access toolbar or Ctrl+Z in case you ever zap something you shouldn’t have!
Figures 3-4 and 3-5 illustrate how Delete works in the example where a duplicate entry has been mistakenly entered in a column of numbers that is totaled by a summing formula. In Figure 3-4, I selected cells A5:B5, which contain duplicate entries, before clicking the Delete button’s drop-down button and then choosing Delete Cells from its drop-down menu to display the Delete dialog box.
Cell Editing 101 195
Figure 3-4:
Deleting a cell with a duplicate entry.
As this figure shows, when the Delete dialog box opens, the Shift Cells Up option button is automatically selected. Figure 3-5 shows the same work- sheet after clicking the OK button in the Delete dialog box. Notice how Excel pulled up the entries in the cells below when it deleted the duplicate in cell B5, while at the same time automatically recalculating the summing formula to reflect the total of the remaining entries.
Book II Chapter 3
Editing and Proofing Worksheets