How do you insert a page break in Excel
You can watch a video tutorial here.
To prepare an Excel sheet for printing, you can specify where you would like the page breaks to appear. This is very helpful in ensuring that the data in the printout is properly arranged without it breaking up and spilling over onto other pages.
Step 1 – Change to the Page Break Preview layout
– Go to View > Workbook views
– Click on Page Break Preview
Step 2 – Insert the page break
– Place the cursor at the location where you want the page break to be inserted (the page break will be inserted above and to the left of the cursor)
– Go to Page Layout > Paget setup > Breaks
– Click on Insert Page Break
Step 3 – Check that the page break is added
– The page break will be inserted above and to the left of the cursor
– The dark, continuous line indicates a custom page break while the dotted line indicates the default page break
Note: If you need a page break to be only above the cursor, place the cursor in the first column. If you need it to be only to the left, place it in the top row.