Removing Cells
In Lesson 6, you learned how to clear the contents and formatting of selected cells. That merely removed what was inside the cells. But sometimes you will want to eliminate the cells completely. When you do, Excel removes the cells and adjusts the data in surrounding cells to fill the gap.
If you want to remove the cells completely, perform the following steps:
Select the range of cells you want to remove.
Open the Edit menu and choose Delete. The Delete dialog box appears.
Select the desired Delete option: Shift Cells Left or Shift Cells Up.
Click OK.
Get Ten Minute Guide to Excel 97 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
