How Can I Get Rid of Page Breaks in Excel?


When using Excel, page breaks are set up for when you get ready to print. The larger the document, the more important these page breaks are. You may want to have the entire worksheet on one page instead of splitting it up. To do this, you have to remove the page break. Removing the page break is slightly different for Mac and PC versions of Excel.

  • Select the worksheet that you would like to print. Select "Page Break Preview," in the View tab.

  • Click the page break that you would like to delete. Click breaks within the page setup menu. "Click "Remove page break."

  • Click "Select All" at the top left-hand corner of the worksheet. Scroll to the Insert menu Select "Reset All Page Breaks."

  • Remove page breaks in the Excel for Mac version by rolling the mouse over the page break -- which is a dotted line. Click on it then go to the Insert Drop-down menu.

  • Scroll down to and select "Remove Page Break." This removes the page break from the worksheet.

Related Searches


  • Photo Credit Stockbyte/Stockbyte/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!