Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-04-2010, 11:09 AM
markg2 markg2 is offline Worksheet copying? Windows 7 Worksheet copying? Office 2007
Expert
Worksheet copying?
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default Worksheet copying?

Windows7 + Office '07

I copied a worksheet to a blank (tab) worksheet for the purpose of using that which I copied as the framework for the new, similar worksheet. To copy I clicked on the box at the upper left corner intersection of the columns and rows that causes all of the sheet to go highlighted to ensure that I was copying all.

All did copy EXCEPT all of the print page setup characteristics. I had to re-enter all.



Is there a way to have the page print settings copy along with all other data and cell settings?

Thanks,

Mark
Reply With Quote
  #2  
Old 01-06-2010, 10:50 AM
mcjohn mcjohn is offline Worksheet copying? Windows Vista Worksheet copying? Office 2007
Novice
 
Join Date: Jan 2010
Posts: 15
mcjohn is on a distinguished road
Default

Try right clicking on the original sheet and selecting 'move or copy'. At the top of the small window that opens click on move to and 'new book' or any other workbook that is open including the original. Be sure to select the 'create copy' box at the bottom unles you want to move the sheet and not leave a copy behind. You can also use this to move/copy sheets between a workbook which is useful if you have hundreds of sheets in one book (like I often have!) and want a sheet moved/copied next to another one far away.
Reply With Quote
  #3  
Old 01-07-2010, 06:03 AM
markg2 markg2 is offline Worksheet copying? Windows 7 Worksheet copying? Office 2007
Expert
Worksheet copying?
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default

I tried right clicking within the original spreadsheet, also in the upper left corner that selects the entire sheet and the copy icon on the ribbon (Excel '07) and in all instances there was no 'window' that opened providing a destination choice as you suggest?
Reply With Quote
  #4  
Old 01-07-2010, 09:20 AM
mcjohn mcjohn is offline Worksheet copying? Windows Vista Worksheet copying? Office 2007
Novice
 
Join Date: Jan 2010
Posts: 15
mcjohn is on a distinguished road
Default

Hi markg2,

It requires you to click on the actul sheet tab itself at the bottom left of excel. So in a brand new workbook for example you would right click on "Sheet1" tab at the bottom left of the screen. Make sense?
Reply With Quote
  #5  
Old 01-07-2010, 10:08 AM
markg2 markg2 is offline Worksheet copying? Windows 7 Worksheet copying? Office 2007
Expert
Worksheet copying?
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default

Ah ha!

Thanks--

Mark
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Headers in Same Worksheet Tom Excel 3 05-18-2011 03:22 PM
Printing multiple page worksheet with watermark zany Excel 2 11-27-2009 01:33 AM
TRANSFER DATA TO NEW WORKSHEET BOBN Excel 0 11-08-2007 10:34 PM
click a cell to go to a worksheet victor Excel 0 10-27-2006 02:57 PM
Worksheet copying? mail receipent with an excel worksheet attachment jburke@holidayinnislip.co Office 1 11-14-2005 08:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft