Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Page set up for a workbook, so each sheet gets the same format ?
I am trying to do a page set up on a workbook at once . I do not want to have
to go to each sheet individually for the set up before printing. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Page set up for a workbook, so each sheet gets the same format ?
You can group the sheets, and any changes made to one of the
sheet will apply to all the sheets. Click the tab of your first worksheet, hold down the SHIFT key and click on the last sheet. All the sheet tabs will appear in white instead of default gray. Make your changes then be sure to ungroup the sheets (right-click and choose Ungroup). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "K_hotmail" wrote in message ... I am trying to do a page set up on a workbook at once . I do not want to have to go to each sheet individually for the set up before printing. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Page set up for a workbook, so each sheet gets the same format ?
Please note if using Chip's suggestion.
Some print setup functions are not available with grouped sheets. Row to repeat at top, columns to repeat at left, Print Range set up among these. These settings require VBA code. Gord Dibben MS Excel MVP On Sun, 11 Jun 2006 11:45:02 -0700, K_hotmail wrote: I am trying to do a page set up on a workbook at once . I do not want to have to go to each sheet individually for the set up before printing. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Page set up for a workbook, so each sheet gets the same format ?
Exchange lots of mouse moves and clicks for a single key press!
Significantly improve working speed by using shortcuts (hot keys). Avoid Repetitive Strain Injury! EnergyKey http://www30.webSamba.com/SmartStudio |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you make a summary page showing the workbook name with the excel sheet names | New Users to Excel | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
Problem with shared workbook (history sheet) | Excel Worksheet Functions |