Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 4th 09, 02:53 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 82
Default How to copy a whole Excel spreadsheet page in 2007 vs 2003?

In Excel 2003 while in a workbook I could go to the Edit drop down menu at
the top bar, and from that choose "Copy or Move...(whole page)". I could use
this to copy a whole page/worksheet -- keeping all the data and the
formatting (for ease of updating reports of data that changes monthly). I
could then update and rename the page. I could even copy the whole
spreadsheet into a new or specified other workbook. This would save me much
time reformatting a blank new spreadsheet with all the same columns,
headings, and repeat of 80% of the data.
Now I have Excel 2007, I cannot find how to copy a whole spreadsheet
page. Can anyone advise me how to do this in Excel 2007? Thanks

  #2   Report Post  
Old November 4th 09, 03:21 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default How to copy a whole Excel spreadsheet page in 2007 vs 2003?

Home Format Move or copy Sheet...

Microsoft has an interactive tool to answer these questions:

http://office.microsoft.com/en-us/he...491511033.aspx

You issue the command as in 2003 and it shows you how to do the same in 2007!!

Spread the word.
--
Gary''s Student - gsnu200908


"Bonnie" wrote:

In Excel 2003 while in a workbook I could go to the Edit drop down menu at
the top bar, and from that choose "Copy or Move...(whole page)". I could use
this to copy a whole page/worksheet -- keeping all the data and the
formatting (for ease of updating reports of data that changes monthly). I
could then update and rename the page. I could even copy the whole
spreadsheet into a new or specified other workbook. This would save me much
time reformatting a blank new spreadsheet with all the same columns,
headings, and repeat of 80% of the data.
Now I have Excel 2007, I cannot find how to copy a whole spreadsheet
page. Can anyone advise me how to do this in Excel 2007? Thanks

  #3   Report Post  
Old November 4th 09, 05:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default How to copy a whole Excel spreadsheet page in 2007 vs 2003?

Right-click on Sheet Tab and "Move or Copy"

2007 and 2003 both the same.


Gord Dibben MS Excel MVP

On Wed, 4 Nov 2009 05:53:01 -0800, Bonnie
wrote:

In Excel 2003 while in a workbook I could go to the Edit drop down menu at
the top bar, and from that choose "Copy or Move...(whole page)". I could use
this to copy a whole page/worksheet -- keeping all the data and the
formatting (for ease of updating reports of data that changes monthly). I
could then update and rename the page. I could even copy the whole
spreadsheet into a new or specified other workbook. This would save me much
time reformatting a blank new spreadsheet with all the same columns,
headings, and repeat of 80% of the data.
Now I have Excel 2007, I cannot find how to copy a whole spreadsheet
page. Can anyone advise me how to do this in Excel 2007? 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
Subtotal by Page in either Excel 2003 or 2007 TAP Excel Discussion (Misc queries) 1 October 6th 08 07:58 PM
I want to resize a page in an Excel 2003 spreadsheet. (80%) mbeav1 Excel Discussion (Misc queries) 0 March 13th 08 04:41 PM
Embedded Excel 2003 spreadsheet in web page won't work with Excel 2007 Ed Flecko Excel Discussion (Misc queries) 0 August 27th 07 09:01 PM
Can I copy page set ups in Excel 2003 from one wksht to another MHacct Excel Worksheet Functions 1 August 9th 07 05:40 PM
How to copy page breaks within an Excel spreadsheet? Warren Excel Discussion (Misc queries) 1 April 6th 06 07:54 PM


All times are GMT +1. The time now is 02:45 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017