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

Chapter 1. Entering Data Annoyances > CUT-AND-PASTE ANNOYANCES

CUT-AND-PASTE ANNOYANCES

PUT MORE THAN ONE ITEM ON THE CLIPBOARD

The Annoyance:

I frequently want to copy items from one workbook into another—or even into another application—and it's tedious having to copy each cell, object, or image one by one, open the other document, paste what I copied, and then go back to my workbook and repeat. Can't I collect what I cut or copy into a single intermediate location and then paste whatever I like?

The Fix:

It is possible to collect items you cut and copy in Excel into a single location, but how you do it changes drastically from version to version. In Excel 97, you'll have to create a separate workbook or worksheet, and paste your collection in there. It's a pain, but it works. Be sure to keep an eye on your workbook's size so that it doesn't slow down your system. I use 1MB as a guideline for when it's time to create a new "holding tank," but if you're running an older system with less memory, you might want to set this limit at 500KB.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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