| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert Multiple Page Breaks
I have a spreadsheet that I want to insert a page break after each row. Is
there a way to do this faster than just highlighting each row and going to Insert - Page Break? I need to do this for about 100 rows. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert Multiple Page Breaks
Insert the pagebreak once, select a new cell and hit F4 (repeat last action)???
If you get both hands moving, you'll be able to hit the downarrow, F4, downarrow, F4, ... Probably lots quicker than any macro solution, too! heater wrote: I have a spreadsheet that I want to insert a page break after each row. Is there a way to do this faster than just highlighting each row and going to Insert - Page Break? I need to do this for about 100 rows. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete page breaks from my documents? | Excel Discussion (Misc queries) | |||
| Page Breaks Won't stay put | Excel Discussion (Misc queries) | |||
| Challenging Charting | Charts and Charting in Excel | |||
| Page breaks don't show on screen and don't print separately. It i. | Excel Discussion (Misc queries) | |||
| insert a page number into a cell? | Excel Worksheet Functions | |||
Hybrid Mode
