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

[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 ?

[Bernie Deitrick]

Anna ,

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

HTH,
Bernie
MS Excel MVP


"Anna Walton" <Anna [email protected]> wrote in message
news:[email protected]...
> 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 ?

[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
=================================
"Anna Walton" <Anna [email protected]> wrote in message
news:[email protected]...
> 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 ?