Friday, April 15, 2011

How Can I Get Rid of Page Breaks in Excel?


1. Select the worksheet that you would like to print. Select 'Page Break Preview,' in the View tab.
2. Click the page break that you would like to delete. Click breaks within the page setup menu. 'Click 'Remove page break.'
3. Click 'Select All' at the top left-hand corner of the worksheet. Scroll to the Insert menu Select 'Reset All Page Breaks.'
4. 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.
5. Scroll down to and select 'Remove Page Break.' This removes the page break from the worksheet.

Blogger news