How to limit number of rows Excel?

S

Surreal

I want to be able to hit "end of page" (CTRL END) and have it go no further
than row 100 and column AZ but i cannot figure out how to do it.
 
K

Kassie

Ctrl end takes you to the bottom right hand of your sheet. If you have data
extending beyond that, Ctrl End will take you beyond that. Try Ctrl G, type
in AZ100
and hit Enter
 
K

Kassie

sorry, you can also record a little macro, assign something like Ctrl e as
shortcut key, and in this way go there.

Sub Macro1()
Application.Goto Reference:="R100C52"
End Sub
 
D

Don S

I want to be able to hit "end of page" (CTRL END) and have it go no further
than row 100 and column AZ but i cannot figure out how to do it.
Click to expand...

You can hide the rows and columns you won't be using. Just select
(place your cursor in the beginnging row to hide) hold down the shift
key and press end+down arrow. Then format / rows / hide. Do the same
for columns.

I use this a lot to define where my worksheets stop so I don't go
paging all over the place for data not in view.

Don S
 
Top