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

Chapter 1. Getting the Most Out of Range... > Inserting a Row or Column with the F...

Inserting a Row or Column with the Fill Handle

You can use the fill handle we looked at earlier to insert entire rows and columns effortlessly. Here's how it works:

1.
Select the row or column where you want to perform the insertion. Notice that the first cell in the row or column contains the fill handle. (If you selected multiple rows or columns, the fill handle appears in the first cell of the last row or column you selected.)

2.
Hold down the Shift key, and click and drag the fill handle in the direction in which you want to insert the rows or columns. The number of rows or columns you drag across determines the number of rows or columns that get inserted.

3.
Release both the mouse button and the Shift key. Excel performs the insertion.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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