| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
changing print area in an entire workbook
I have done everything that the help has given me. I need to print out a
spreadsheet that has 31 tabs. I want to change the original print area to a new one on all the sheets. I can't seem to accomplish this. I have tried to right click the tabs and choose select (group) I have tried to name ranges with the ='day1:day31'!a1:j48. This only works on 1 or two pages. Is there a way to remove an existing print range and replace it with a new one in an entire workbook? This would be helpful as I need to print out the daily production for 2 1/2 years (1000 sheets of paper). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
| Print Spreadsheet tabs in a Workbook to a List? | Excel Discussion (Misc queries) | |||
| Excel should let me set the print default to "Entire Workbook". | Setting up and Configuration of Excel | |||
| Changing print area | Excel Discussion (Misc queries) | |||
Threaded Mode
