Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Select All question
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Select All question
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...x2k.htm#foobar -- Regards, Peo Sjoblom "P D Sterling" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Select All question
Peo Sjoblom wrote:
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...x2k.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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Select All question
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. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "P D Sterling" wrote in message ... Peo Sjoblom wrote: 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...x2k.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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Select All question
Ron de Bruin wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rows().select VBA question | Excel Discussion (Misc queries) | |||
Question with use of advanced filter to select empty cells | Excel Discussion (Misc queries) | |||
New excel user question: Incase of tie, select latest date | New Users to Excel | |||
VBA select case question | Excel Discussion (Misc queries) | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) |