Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to group rows or columns on an excel worksheet | Excel Discussion (Misc queries) | |||
inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
Repeating Rows and Columns on each page of print out | Excel Discussion (Misc queries) | |||
How Do I create a worksheet with rows and columns | New Users to Excel | |||
Display specific rows from table on other worksheet | Excel Discussion (Misc queries) |