Limit Scrolling

  • Thread starter Thread starter gml
  • Start date Start date
G

gml

Is there a way to limit scrolling. I don't need thousands
of rows and columns, but when highlighting areas and then
scrolling to the bottom and/or right of my worksheet I'm
suddenly hundreds of rows beyond my simple (say 100-row 25-
column table). Freezing panes, splitting etc. don't seem
to help much... all those extra rows etc. are still there
 
Hi gml!

Two approaches here; hiding the "excess" rows and columns or limiting
scroll area through VBA.

Too hide excess rows:

Select the first empty row after your desired limit.
Ctrl+Shift+Down Arrow will select to the end of the rows (Row 65536).
While these remain selected use:
Format > Rows > Hide.

Then it's the same with columns:

Select the first column to the right of your desired limit.
Ctrl+Shift+Right Arrow will select to column IV
While they are selected use:
Format > Column > Hide

If you're into VBA then use a command in the following form

Worksheets("Sheet1").ScrollArea = "A1:H200"

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Saturday 26th July: Andorra (Sant Julia De
Loria), Argentina (Eva Peron Day), Brazil (Day of Iansa), Cuba (Anniv
of the Moncada Barracks Attack Day), Haiti (Gran'Delai et Gran'
Aloumandia (Sainte Anne), Liberia (Independence Day), Maldives
(Independence Day), USA (New York State Ratification Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top