| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Page and Print Formatting
I have a workbook with 17 worksheets. How do I copy the page and print
layouts (margins, footer, orientation, etc) from one worksheet to all the rest without having to do each one individually? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Page and Print Formatting
In 2003 I would select all sheets and do the page setup on the active sheet.
Most settings will be the same for all sheets ion the group. A couple that cannot be done with grouped sheets is printrange and rows to repeat at top. I don't think 2007 would be much different. Gord Dibben MS Excel MVP On Sun, 25 Jan 2009 10:24:00 -0800, Redwingwill wrote: I have a workbook with 17 worksheets. How do I copy the page and print layouts (margins, footer, orientation, etc) from one worksheet to all the rest without having to do each one individually? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Page and Print Formatting
THANKS GORD - SO SIMPLE!!!
"Gord Dibben" wrote: In 2003 I would select all sheets and do the page setup on the active sheet. Most settings will be the same for all sheets ion the group. A couple that cannot be done with grouped sheets is printrange and rows to repeat at top. I don't think 2007 would be much different. Gord Dibben MS Excel MVP On Sun, 25 Jan 2009 10:24:00 -0800, Redwingwill wrote: I have a workbook with 17 worksheets. How do I copy the page and print layouts (margins, footer, orientation, etc) from one worksheet to all the rest without having to do each one individually? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Page and Print Formatting
Hi Gord,
Yes, Excel 2007 is exactly the same although you can do the page headers and footer in the spreadsheet rather than in the Page Setup dialog box (but its there if you want it). Tip: Ctrl+F2 is the shortcut key for print preview command in 2007. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Gord Dibben" wrote: In 2003 I would select all sheets and do the page setup on the active sheet. Most settings will be the same for all sheets ion the group. A couple that cannot be done with grouped sheets is printrange and rows to repeat at top. I don't think 2007 would be much different. Gord Dibben MS Excel MVP On Sun, 25 Jan 2009 10:24:00 -0800, Redwingwill wrote: I have a workbook with 17 worksheets. How do I copy the page and print layouts (margins, footer, orientation, etc) from one worksheet to all the rest without having to do each one individually? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 Page and Print Formatting
Thanks Shane.
Will start the install of Office 2007 Ultimate today.................maybe<g Gord On Sun, 25 Jan 2009 12:38:06 -0800, Shane Devenshire wrote: Hi Gord, Yes, Excel 2007 is exactly the same although you can do the page headers and footer in the spreadsheet rather than in the Page Setup dialog box (but its there if you want it). Tip: Ctrl+F2 is the shortcut key for print preview command in 2007. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 won't print whole page | Excel Discussion (Misc queries) | |||
| print chart on full page in Excel 2007 | Charts and Charting in Excel | |||
| First page of Excel sheerepeats in print layout or print preview | Excel Discussion (Misc queries) | |||
| Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
| Excel saving as web page and scaling the print out to fit one page | Excel Discussion (Misc queries) | |||
Linear Mode
