Home |
Search |
Today's Posts |
#1
|
|||
|
|||
The recalcitrant active cell.
I am way over in column EO, reconnoitring data, when I need assistance of a "what if", I activate the auto filter, and the active cell jumps back to A1. any workarounds for this annoying habit? Thanks in advance. |
#2
|
|||
|
|||
Works for me, if I filter on something in one column and the active cell is
there as well it won't change to A1 2 guesses, your active cell was A1 from the start even though you filtered on EO you have a recorded macro that was setup to go back to A1 -- Regards, Peo Sjoblom "Rodney" wrote in message ... I am way over in column EO, reconnoitring data, when I need assistance of a "what if", I activate the auto filter, and the active cell jumps back to A1. any workarounds for this annoying habit? Thanks in advance. |
#3
|
|||
|
|||
Thank you Peo, for your effort to respond.
I have to admit, it was an "embarrasing moment" for me. I have MSWorks keystrokes ingrained, and when I activated the Auto filter, the screen indeed flicks to the Upper LHS of the worksheet (A1), but the active cell remained at EO. All I need to do is to hit a down arrow, for the screen to flick back to EO. Prior to this, I was hitting F5, to go back to my EO column. which was annoying additional keystrokes. Best regards. | Works for me, if I filter on something in one column and the active cell is | there as well it won't change to A1 | 2 guesses, your active cell was A1 from the start even though you filtered | on EO | you have a recorded macro that was setup to go back to A1 | Regards, Peo Sjoblom | I am way over in column EO, reconnoitring data, | when I need assistance of a "what if", | I activate the auto filter, and the active cell jumps back to A1. | any workarounds for this annoying habit? | | Thanks in advance. | | | | | | |
#4
|
|||
|
|||
Thanks for the feedback
-- Regards, Peo Sjoblom "Rodney" wrote in message ... Thank you Peo, for your effort to respond. I have to admit, it was an "embarrasing moment" for me. I have MSWorks keystrokes ingrained, and when I activated the Auto filter, the screen indeed flicks to the Upper LHS of the worksheet (A1), but the active cell remained at EO. All I need to do is to hit a down arrow, for the screen to flick back to EO. Prior to this, I was hitting F5, to go back to my EO column. which was annoying additional keystrokes. Best regards. | Works for me, if I filter on something in one column and the active cell is | there as well it won't change to A1 | 2 guesses, your active cell was A1 from the start even though you filtered | on EO | you have a recorded macro that was setup to go back to A1 | Regards, Peo Sjoblom | I am way over in column EO, reconnoitring data, | when I need assistance of a "what if", | I activate the auto filter, and the active cell jumps back to A1. | any workarounds for this annoying habit? | | Thanks in advance. | | | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
reading blank cell as active - how can I stop it ? | Excel Discussion (Misc queries) | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
Highlight Active Cell...With a Diffrence | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel |