How do I hide all of the cell that I don't use.

  • Thread starter Thread starter Geek
  • Start date Start date
G

Geek

Hi again,

OK. Now that I have created my spreadsheet I thought there was a function in
which I could just view the cells or portion of the sheet that I have
created. Is there some what to make the unused portion of a sheet go away?
 
Hi
you could hide all rows/columns which you don't use (goto 'Format -
Rows/Columns' to do this)
 
Geek

You can't make them "go away".

You can hide the rows and columns you don't want to see. Select them and
Format>Hide.

Alternative.........You may want to try setting the Scroll Area.

This setting will not remain after closing the file.
Place a code line in the Workbook open event to set it
each time when you open the workbook

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A1:H40"
End Sub

Adjust to your sheetname and range.

Gord Dibben Excel MVP
 
When you say hide the rows is that because unnecessary
pages are being printed. If so do a search on Google Groups
I have three postings since March 10th.

Quick test, if Ctrl+End is not at the intersection of your
last used row and your last used column then look at these
three posted replies.
Re: MS Excel Very Slow to Open and Save.
http://google.com/[email protected]

Re: File size is larger in XP than in Excel 97
http://google.com/[email protected]

Re: Excel 2003 [a very poor choice for a subject title in an Excel group]
http://google.com/groups?threadm=#[email protected]

The above were found because I know I am looking for
words in message: makelastcell
author: (e-mail address removed)
http://google.com/advanced_group_search?q=group:*Excel*&num=100

But you would likely find something if you did you own search with
some of the words in your own question. But a macro is so
much easier than manually deleting rows and columns.

More information on searching newsgroup and shortening
a Google Groups link that still shows the actual all important
message-id in it for the best reference.
http://www.mvps.org/dmcritchie/excel/xlnews.htm
 
Back
Top