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

Chapter 1. Getting the Most Out of Ranges > Inserting an Entire Row or Column

Inserting an Entire Row or Column

The easiest way to insert a range into a worksheet is to insert an entire row or column. The following steps show you how it's done:

1.
Select the row or column before which you want to insert the new row or column. If you want to insert multiple rows or columns, select the appropriate number of rows or columns, as shown in Figure 1.16.

Figure 1.16. Two rows have been selected at the point where two new rows are to be inserted.


2.
If you're inserting rows, choose Insert, Rows. Excel shifts the selected rows down, as shown in Figure 1.17. If you're inserting columns, choose Insert, Columns instead. In this case, Excel shifts the selected columns to the right.



Figure 1.17. When you insert rows, Excel shifts the existing cells down.


3.
After inserting the row or column, Excel displays the Insert Options control. Click the arrow to display the list (shown in Figure 1.17), and then click the formatting option you prefer (the choices are slightly different if you inserted columns instead of rows):

  • Format Same As Above— Click this option to format the new rows using the same formatting as the row directly above them.

  • Format Same As Below— Click this option to format the new rows using the same formatting as the row directly below them.

  • Clear Formatting— Click this option to insert the new rows without any formatting.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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