Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I do one-time printing without set page breaks?
I have a Excell document with set page breaks. Sometimes I sort differently
and want to print that without the page breaks. How can I do that without having to remove my previous page breaks and then inserting them again? Thanks! |
#2
|
|||
|
|||
hi,
you can't. but you can record print macros for each way you wish to print including changing headers and footers. you can do each on macro record. this way you don't have to re-set everything back up. the print macro will do that for you. all you do is click macro run. just a suggestion. i use this technique. regards FSt1 "kewlblondboy" wrote: I have a Excell document with set page breaks. Sometimes I sort differently and want to print that without the page breaks. How can I do that without having to remove my previous page breaks and then inserting them again? Thanks! |
#3
|
|||
|
|||
Save your workbook the way you want.
sort your data remove the page breaks close without saving or copy the worksheet and work on that copy. print that "helper" worksheet delete that "helper" worksheet kewlblondboy wrote: I have a Excell document with set page breaks. Sometimes I sort differently and want to print that without the page breaks. How can I do that without having to remove my previous page breaks and then inserting them again? Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple page printing | New Users to Excel | |||
printing multiple page workbook | Excel Discussion (Misc queries) | |||
Printing Landscaped and Portrait worksheets at same time...XP | Excel Discussion (Misc queries) | |||
Printing on one page | Excel Discussion (Misc queries) | |||
Printing multiple portait and landscape workbooks at the same time | Excel Discussion (Misc queries) |