insert copied cells
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 |
insert copied cells
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 |
All times are GMT +1. The time now is 07:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com