#1   Report Post  
CP
 
Posts: n/a
Default

HI:


I should have made it a bit clearer. I'm actually within the same
worksheet. So in instead copy and pasting, then scrolling down to the next
page 20 times and doing a copy & paste I was wondering if there was a faster
way. So if I am to print it the same cells would appear on each of the 20
pages...



"SVC" wrote:

If the cells are the same on all the sheets (e.g. A1, B1, C2) and all need
the same data, right click the active sheet tab and Select all. Now enter
the numbers in the appropriate cells on the active worksheet, right click the
sheet tab again and Upgroup sheets. The numbers should now appear on all the
sheets.

If the cells are in various locations on the different sheets, cut and paste
is probably the only solution.

"CP" wrote:

Hi: I have created some cells on a page. I need to have them repeated on
continous pages. Instead of highlighting them and copy & paste on the next
page, is there a way to do this with one command? I need to to repeated on
20 pages. Thanks.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Copy and Paste or Paste Special between Excel Workbooks wllee Excel Discussion (Misc queries) 5 April 29th 23 03:43 AM
I cannot paste from one workbook to another. Copy works, paste do. JimmyMc Excel Discussion (Misc queries) 1 June 10th 05 03:54 PM
Can't Copy and Paste between Excel 2003 Workbooks wllee Excel Discussion (Misc queries) 6 March 30th 05 02:59 PM
Copy & Paste Brian Keanie Excel Discussion (Misc queries) 1 February 5th 05 11:56 AM
copy paste cell character limit Fred Excel Discussion (Misc queries) 1 December 2nd 04 08:58 PM


All times are GMT +1. The time now is 12:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"