Sunday, December 11, 2011

How to Remove Page Breaks From Excel 2007


1. Open the Excel file in which you'd like to remove a page break. Click the 'View' tab at the top of the screen.
2. Click 'Page Break Preview' in the 'Workbook Views' group. This allows you to see your manual page breaks.
3. Click the row or column label after the page break you wish to delete. As an example, to delete the page break between columns E and F, you would click the top 'F' column label, which selects the entire F column. Likewise, click the '20' row label to select the page break between rows 19 and 20.
4. Click the top 'Page Layout' tab.
5. Click 'Breaks' in the 'Page Setup' group, and select 'Remove Page Break.' Alternatively, select 'Reset All Page Breaks' to remove them all.
6. Click the 'View' tab, and click 'Normal' in the 'Workbook Views' group to return to your normal view mode.

Blogger news