Filter Question

  • Thread starter Thread starter Rebecca
  • Start date Start date
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.
 
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.
 
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.
Click to expand...
 
Back
Top