How do I limit the visible rows in Excel?

T

tomcheesewright

I want to hide everything in a worksheet except for the table into which I am
asking others for input. Columns are easy, but how can I hide ALL the rows
below my chart? I could colour them out in black, that would lead to
printing issues.

Help please!
 
P

Peter Rooney

Tom,

One way I like to restrict access is by defining a scroll area thus:

Sub DefineScrollArea()
ActiveSheet.ScrollArea = "MyCellRange"
End Sub

Once you run this macro, you can only move the cursor to a cell within this
range.
You can also use cell addressses instead of the "MyCellrange" range name

Sub DefineScrollArea()
ActiveSheet.ScrollArea = "B5:G25"
End Sub

To turn this function off, use a macro like this:

Sub ResetScrollArea()
Worksheets("Database").ScrollArea = ""
End Sub

To hide the contents of worksheet cells, select them, then go into Format
Cells Number Custom and enter ;;; (three semicolons) in the type box.

This will hide everything in the delected cells without you having to change
the colours. To reset this, reset the cell format to general, or something
like that.

You can also hide rows by selecting them the clicking Format Rows Hide.

Hope this helps

Pete
 
P

paul

set the print area file>printarea>set print area to incluse only your chart
and on the screen select your table then on the std toolbar click on the zoom
box and select "selection".If you want to hide data highlight the rows you
want to hide on the very left margin >right click>hide
 
G

Gilly Hampshire

Hi Tom,

To hide rows do the following
1) Click the first row number you want to hide, this will select the whole row
2) Press Ctrl+Shift+the down arrow key, this will select ALL the rows below.
3) Select 'Format' on the Menu toolbar and choose 'Row', then select 'Hide'

All the selected rows will now be hidden and a grey moat will appear.

Hope this helps
 
Top