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 ?