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

two rows so that you have selected the three cells with entries that you want to retain but also need to have moved down.
Figures 3-6 and 3-7 illustrate this situation. In Figure 3-6, I selected the cell range A5:B7, where cells for the six missing entries are to be inserted. I then clicked the drop-down button on the Insert button followed by Insert Cells on its drop-down menu. This action opened the Insert dialog box with the Shift Cells Right option button selected. Because I needed to have the cells in the selected range moved down to make room for the missing entries, I then simply selected the Shift Cells Down option before selecting OK.
Figure 3-6:
Inserting six blank cells for missing entries
in two columns of a table while shifting the existing entries down.
Figure 3-7:
The worksheet table after entering the missing entries in the newly inserted blank cells.
Cell Editing 101 197
Book II Chapter 3
Editing and Proofing Worksheets