CTRL A doesn't work on a range of cells

[Guest]

On some of our company laptops clicking into a range of cells and CTRL A just
selects the range. In others it selects the whole worksheet. The cursor is
actually in the range and CTRL * works. Is there a setting that has been
changesd?

Thanks

Diane

 

[Dave Peterson]

No setting has been changed, but the way ctrl-a works has been changed through
versions of excel.

It depends on the location of the activecell, what surrounds that cell and what
version of excel you're using.

David McRitchie supplies a macro that tries to make ctrl-a in xl2003 behave the
same way as earlier versions.

(I've learned to just keep clicking ctrl-a until I'm happy.)

 

[Ron de Bruin]

Note: in Excel 2007 it is possible that you must use CTRL+A three times before are cells are selected.

If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its
summary rows. Pressing CTRL+A a third time selects the entire worksheet.