View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Daniel CHEN
 
Posts: n/a
Default 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 ?