• 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 Range with the Fill Hand...

Inserting a Range with the Fill Handle

The fill handle also comes in handy when you are inserting a range:

1.
Select the range in which you want the insertion to occur.

2.
Hold down the Shift key, and click and drag the fill handle over the area where you want the new range inserted.

3.
Release the mouse button and the Shift key. Excel inserts the range.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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