ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to copy a whole Excel spreadsheet page in 2007 vs 2003? (https://www.excelbanter.com/excel-discussion-misc-queries/247480-how-copy-whole-excel-spreadsheet-page-2007-vs-2003-a.html)

Bonnie

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

Gary''s Student

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


Gord Dibben

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




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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com