| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Area
I need to print everything between A1:P80, except for row 39. I need this
printed all on one sheet without having to hide row 39. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print Area
I'd use a macro to do the work.
Record a macro when you hide row 39 and setup the page to print on one sheet. Then continue recording when you print and unhide that row and change the print settings back. Then stop recording. Troy 2006 wrote: I need to print everything between A1:P80, except for row 39. I need this printed all on one sheet without having to hide row 39. Is this possible? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
| File, print area, clear area, is not working | New Users to Excel | |||
| print area across the freeze panes area | Excel Worksheet Functions | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
![Troy 2006[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
