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

Copying a Range

The quickest way to become productive with Excel is to avoid reinventing your worksheet wheels. If you have a formula that works or a piece of formatting that you've put a lot of effort into, don't start from scratch to create something similar. Instead, make a copy and then adjust the copy as necessary.

Fortunately, Excel offers all kinds of ways to make copies of your worksheet ranges. Most of these methods involve the Copy command, but I'll begin by showing you the very handy drag-and-drop method.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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