How do I reduce the no. of rows & columns in a worksheet ?

A

Anna Walton

When you apply a print area to a worksheet, how do you then delete the rest
of the worksheet not in your selected area ?

In worksheets where this has been done already, a thick blue line appears
around the side. How do you then undo this format and add rows and columns to
this spreadsheet ?
 
B

Bernie Deitrick

Anna ,

Under 'View", change to 'Normal' rather than the 'Page Break Preview"

HTH,
Bernie
MS Excel MVP
 
D

Daniel CHEN

You can drag the thick blue line up/down/left/right to change the print
area.
Or you can go to menu File/Print Area/Clear Print Area to clear it and then
File/Print Area /Set Print Area to set what you want.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
 
Top