Select All question

P

P D Sterling

At home I have Excel 2002 and am very happy with it. At work, I have
Excel 2003, and I find it disconcerting that, when I hit a Ctrl + A, it
selects a range of its own choosing, within the work I am most currently
on. When I say Select All, I mean Select All - is there some option that
is incorrectly set? I have looked all over the Customize and Options
areas. Any advice would be gratefully appreciated.
--

Regards,

P D Sterling
Florida, New York USA
 
P

Peo Sjoblom

True, they added an annoying thing in 2003, you need to do it twice in Excel
2003 for it to select all, wait it gets worse! In Excel 2007 you have to
press Ctrl + A 3 times to select all! One press selects current region
although there was already a shortcut for that Ctrl + *


Here's a method showing how to restore it using code

http://www.mvps.org/dmcritchie/excel/shortx2k.htm#foobar






--


Regards,


Peo Sjoblom
 
P

P D Sterling

Peo said:
True, they added an annoying thing in 2003, you need to do it twice in Excel
2003 for it to select all, wait it gets worse! In Excel 2007 you have to
press Ctrl + A 3 times to select all! One press selects current region
although there was already a shortcut for that Ctrl + *


Here's a method showing how to restore it using code

http://www.mvps.org/dmcritchie/excel/shortx2k.htm#foobar
1) I thank you most deeply for the answer

2) however, it has given me a headache, and I will have to digest it all
later. why doesn't uncle bill understand that some people are getting
too old to have to learn new stuff? now I know I will never get rid of
my Office 2002. here's hoping I can retire soon!

regards,
pds

--

Regards,

P D Sterling
Florida, New York USA
 
P

P D Sterling

Ron said:
H P D Sterling

This is working in all Excel versions:
Click on the space above the first row header and on the left of the
first column header.

Excel 97-2002:
Use the shortcut Ctrl-a to select all cells.

Excel 2003:
If the worksheet contains data, CTRL+A selects the current region.
Pressing CTRL+A a second time selects the entire worksheet.
Excel 2007:
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.
I know you mean well, and I am sincere when I say, I am not a mouse
person. I have been working with computers since before there were PCs,
and I find it much easier to mash a CTRL + A than to find the mouse,
find the leftmost, topmost cell, etc. I am trying to learn it, but I
guess I will just hit CTRL + A up to 17 times as needed!
--

Regards,

P D Sterling
Florida, New York USA
 

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

Similar Threads

problem with Data|Text to Columns 2
problem with wrap text 4
need to edit blank email 8
vlookup or what? 3
Question about protecting 2
Virtual Printer (?) 7
Navigation problems 2
Hot Links or Hyperlinks 2

Top