![]() |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 05:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com