• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Structuring the Sheet > Inserting Rows and Columns

Inserting Rows and Columns

You can insert rows and columns at any time, and Excel adjusts all formulas to accommodate the new rows or columns. If you insert a row, it will appear above the selected cell; if you insert a column, it will appear to the left of the selected cell.

To insert a row or a column:

1.
Click any cell of the row or column in which you’d like to insert the new blank row or column (Figure 12.5).

Figure 12.5. Click a cell in the row where you want to insert a new row.


2.
From the Insert menu, choose Rows to insert a row or choose Columns to insert a column.

3.
Click the Insert Options button to choose formatting options from the row or column (Figures 12.6 and 12.7).

Figure 12.6. The new blank row appears.


Figure 12.7. Choose a formatting option.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint