Scroll tabs

  • Thread starter Thread starter Engineer Mark
  • Start date Start date
E

Engineer Mark

In very large spreadsheets I often want to scroll down to a specific row
multiple times. Does Excel have anything similar to a tab or marker that you
could place on the scroll bar. You could click on it and jump to a specific
row of the spreadsheet?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
 
Press F5. In reference type the refernce for example for row 300..type A300.
hit OK
Another way is to type the reference in the name box. Name box is the small box just above cell A1.
Click to expand...

If this post helps click Yes
 
Another option would be to insert a hyperlink to whichever cell(s) you
wish to scroll.

Right-click on the cell you will be moving from
Choose Hyperlink...
Type a label to appear as the link (eg Go to A500)
Click the Place in This Document option on the left
Type in the target cell address or select a named range if one already
exists
Click OK

It's nice to make a link back to the starting point if others will be
using the worksheet :)
 
You can name often-used cells then pick the name from the namebox.


Gord Dibben MS Excel MVP

On Wed, 28 Oct 2009 07:59:01 -0700, Engineer Mark <Engineer
 
Back
Top