Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal by Page in either Excel 2003 or 2007 | Excel Discussion (Misc queries) | |||
I want to resize a page in an Excel 2003 spreadsheet. (80%) | Excel Discussion (Misc queries) | |||
Embedded Excel 2003 spreadsheet in web page won't work with Excel 2007 | Excel Discussion (Misc queries) | |||
Can I copy page set ups in Excel 2003 from one wksht to another | Excel Worksheet Functions | |||
How to copy page breaks within an Excel spreadsheet? | Excel Discussion (Misc queries) |