Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sandhya
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CONCATENATE problem with blank cells roger_home Excel Discussion (Misc queries) 1 August 17th 05 09:18 PM
Blank cells represented in area charts cdoughty Charts and Charting in Excel 2 August 6th 05 06:02 PM
Chart to display only bars for values that are > 3 & blank cells Neil Goldwasser Excel Worksheet Functions 1 August 4th 05 09:37 PM
Blank Cells in Pivot Tables Greg Excel Discussion (Misc queries) 1 March 16th 05 10:23 PM
Non Blank - Blank Cells???? Reggie Excel Discussion (Misc queries) 3 January 12th 05 01:04 AM


All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"