Scroll tabs

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
 
J

Jacob Skaria

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.

If this post helps click Yes
 
A

Amish

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 :)
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top