ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to make unused cells blank (https://www.excelbanter.com/excel-discussion-misc-queries/65379-how-make-unused-cells-blank.html)

Sandhya

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

Pete

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


Niek Otten

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




Sloth

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