Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make unused cells blank
I have used 6 columns and 4 rows of a excel worksheet and i would like the
rest of the sheet look blank without even the cells visible.how to do it |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make unused cells blank
Highlight column G by clicking the identifier. Hold down <shift and
press <end once followed by <right-arrow, the release <shift. Then select Format | Column | Hide. Do a similar thing to the rows by selecting row 5 first and using down-arrow. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make unused cells blank
FormatColumnsHide
Same for Rows -- Kind regards, Niek Otten "Sandhya" wrote in message ... I have used 6 columns and 4 rows of a excel worksheet and i would like the rest of the sheet look blank without even the cells visible.how to do it |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make unused cells blank
you can hide them. Highlight column G and hit ctrl+shift+right. Right click
the selected area and select hide. Highlight row 5 and hit ctrl+shift+down. Right click the selected area and select hide. "Sandhya" wrote: I have used 6 columns and 4 rows of a excel worksheet and i would like the rest of the sheet look blank without even the cells visible.how to do it |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
Blank cells represented in area charts | Charts and Charting in Excel | |||
Chart to display only bars for values that are > 3 & blank cells | Excel Worksheet Functions | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Non Blank - Blank Cells???? | Excel Discussion (Misc queries) |