This is one of David's pet peeves <vbg.

Personally, I just keep hitting ctrl-a and watch the screen. But I'm too lazy
to care about the change <bg.

Charlie wrote:

Found it. (Assign macro to a key.)

"Dave Peterson" wrote:

David McRitchie's has a macro workaround:
http://mvps.org/dmcritchie/excel/shortx2k.htm#foobar



Charlie wrote:

Is it my imagination or has the Ctrl-A (Select All) shortcut key changed? It
seems that it always used to select the entire sheet, the same as clicking
the button in the upper-left corner of the sheet.

Now when I press Ctrl-A it only selects a range of used cells based on the
location of the active cell. If I move to a different cell and press Ctrl-A
I get a different range highlighted. Only if my active cell is not in what
is considered a range of used cells does Ctrl-A select the entire sheet.

Has it always been this way? Did I just never stumble upon it? Is my
Alzheimer's acting up again? Or did I inadvertently change the operation of
Ctrl-A somehow (is there an option somewhere? I could not find any.)

TIA
Charlie

--

Dave Peterson


--

Dave Peterson