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

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 ?

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

Anna ,

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

HTH,
Bernie
MS Excel MVP


"Anna Walton" <Anna wrote in message
...
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 ?

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

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
=================================
"Anna Walton" <Anna wrote in message
...
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 ?