Using Excel 03/WinXP. I need to paste a copied range of cells multiple times
onto different worksheets. After selecting the range and doing a copy, I use
the option Insert, Copied cells. However, when clicking on the Insert menu
again, the Copied cells option is no longer available - only Cells is listed.
Is there a way to be able to use the Insert, copied cells multiple times
without having to recopy the range?
--
maryj

Hi maryj-

Are you doing the Insert because you actually need to make room within
existing data to paste the new stuff? If not, just use the normal paste
command and you can paste as many times as you wish anywhere you want. In
fact, if the data is being pasted into the _same_ area on each sheet & the
sheets are consecutive in the book, you can click the first tab, Shift+click
the last, and paste once.

OTOH, if you do have to make room on the other sheets, that's a different
story.

Either way, the question I would ask is "Why is the same data is being
stored in so many different locations?". It would seem there must be a better
approach.

Regards |:)

"maryj" wrote:

Using Excel 03/WinXP. I need to paste a copied range of cells multiple times
onto different worksheets. After selecting the range and doing a copy, I use
the option Insert, Copied cells. However, when clicking on the Insert menu
again, the Copied cells option is no longer available - only Cells is listed.
Is there a way to be able to use the Insert, copied cells multiple times
without having to recopy the range?
--
maryj