Need help with worksheet navigation

  • Thread starter Thread starter JAF
  • Start date Start date
J

JAF

Imagine yo have a worksheet with 2000 rows. Moving the right scroll
bar down takes you to the 2000th row.

But if you remove or delete the last 1000 rows, when you use the
scroll bar to move to the end of the worksheet, yo still go to the
2000 row, not the 1000th row.

Is there any way to limit the number of rows in a woksheet?

I often hav emuch shorter worksheets, say with 200 rows, and I am
always shooting way past the last row when block or navigating.

Is ther a way to stop this?

Thanks.


Best regards,

JAF
http://www.discountdrivingschool.com
 
How about some alternatives.

Hit ctrl-end to get to the end and the work your way up.

Click on the top cell and use the scroll bar to get to the bottom and then shift
click on it.

If you know the address to select:
edit|goto
type the address
click ok.
 
I appreciate your posting. I have tried some of these. And you have
given me some new tips to try.

But I find that many times I am moving around a spreadsheet and often
shoot way past the end of the sheet.

It is ashame there isn;t some way to mark the last row somehow, and
then never be able to go past it without removing that mark.

Kind of like moving around a Word doc and never being able to go
beyond the last character you entered.

Again thanks for your postings.



Check Debra Dalgleish's site:
http://contextures.com/xlfaqApp.html#Unused
Click to expand...

Best regards,

JAF
http://www.discountdrivingschool.com
 
You could hide the rows after the last row you used--but I've found that more
irritating than scrolling past the last cell.

When I have to select (say) A1 to the bottom right corner, I'll hit ctrl-end and
look for the cell that I need--if I've gone past it.

Then Ctrl-Shift-Home to select that cell through A1.
 
If you deleted the excess rows and columns with
Debra's macro then you can look at the scroller
how big is it, compared to the slot in the scroll bar
that is slides in. Drag the scroller down until it
reaches the end of the slot it is in.

Shortcut keys Ctrl+End will take you the
lastcell as known by Excel. see
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
http://www.mvps.org/dmcritchie/excel/lastcell.htm
for other navigations see
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse

If you want to go to a specific address then use
the "name box" to the left of the "formula bar".

If you want to go to the last cell in a column
you could go down to the bottom say B65536
into the name box then End+ArrowUP but
that is a lot easier done with a macro and a
toolbar button so see
http;//www.mvps.org/dmcritchie/excel/toolbars.htm#customdn
--
 
Back
Top