ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to copy page breaks within an Excel spreadsheet? (https://www.excelbanter.com/excel-discussion-misc-queries/81843-how-copy-page-breaks-within-excel-spreadsheet.html)

Warren

How to copy page breaks within an Excel spreadsheet?
 
I am trying to duplicate several hundred rows of data, within an Excel
Spreadsheet, with embedded Page Breaks in. After copying the data I have to
go through the new data inserting all the Page Breaks by hand.

JR

How to copy page breaks within an Excel spreadsheet?
 
If each section of data is the same number of lines, just adjust the bottom
margin up to include the given number of lines. Go to "Print Preview", click
"Margins" button, then drag the lower margin line up.

"Warren" wrote:

I am trying to duplicate several hundred rows of data, within an Excel
Spreadsheet, with embedded Page Breaks in. After copying the data I have to
go through the new data inserting all the Page Breaks by hand.



All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com