Excel 2010 Bible

Part I: Getting Started with Excel

66

FIGURE 3.11

You can’t add a new row or column if it causes nonblank cells to move off the worksheet.

FIGURE 3.12

You can insert partial rows or columns by using the Insert dialog box.

Deleting rows and columns .......................................................................................

You may also want to delete rows or columns in a worksheet. For example, your sheet may contain

old data that is no longer needed.

To delete a row or rows, use either of these methods:

l Select an entire row or multiple rows by clicking the row numbers in the worksheet bor-

der. Right-click and choose Delete from the shortcut menu.

l Move the cell pointer to the row that you want to delete and then choose Home ➪

Cells ➪ Delete Sheet Rows. If you select multiple cells in the column, Excel deletes all

rows in the selection.

Deleting columns works in a similar way. If you discover that you accidentally deleted a row or

column, select Undo from the Quick Access toolbar (or press Ctrl+Z) to undo the action.

Hiding rows and columns .........................................................................................

In some cases, you may want to hide particular rows or columns. Hiding rows and columns may

be useful if you don’t want users to see particular information, or if you need to print a report that

summarizes the information in the worksheet without showing all the details.

Cross-Reference
Chapter 26 discusses another way to summarize worksheet data without showing all the details — outlining. n