Filter Question

R

Rebecca

Greetings. I am using VISTA and Excel 2007. When using a "Filter by Selected
Cell's Value," I often get a long list of rows (say, 453 rows). Is there some
way or some hotkey / shortcut that I can use to reach the bottom of the rows
that appear in that particular filter? I usually have to scroll down with my
mouse, but it would be nice to be able to jump to the bottom more quickly.
Thanks.
 
R

Roger Govier

Hi Rebecca

Whether a list is filtered or not, you can always jump to the last entry in
that column.
With any cell selected, hover the cursor over the bottom line of a cell
until you see a 4 sided arrow
Double click on the bottom line and you will be taken to the last cell in
the column.

Each of the other directions works as well.
 
R

Rebecca

Thanks, Roger, as always.

Roger Govier said:
Hi Rebecca

Whether a list is filtered or not, you can always jump to the last entry in
that column.
With any cell selected, hover the cursor over the bottom line of a cell
until you see a 4 sided arrow
Double click on the bottom line and you will be taken to the last cell in
the column.

Each of the other directions works as well.
 

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

Top