| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using ctrl+A
I am trying to highlight all of the information in my speadsheet using
ctrl+A. When I press ctrl+a, howeveer, only a portion of my data is highlighted. What can I do to make this function work the way it's supposed to? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using ctrl+A
It is a toggle. You hit it once and it will select the Current Region. Hit
it again and the entire sheet will be selected (the cells). HTH -- Regards, Zack Barresse, aka firefytr "guyd" wrote in message ... I am trying to highlight all of the information in my speadsheet using ctrl+A. When I press ctrl+a, howeveer, only a portion of my data is highlighted. What can I do to make this function work the way it's supposed to? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using ctrl+A
Hi guyd
This is a stupid change in 2003 It will select the current region the first time and the second time the whole sheet. (We already hade the shortcut Ctrl-* to select the current region) In Excel 2007 it is possible that you must use it three times Best is to click on the space above the first row header and on the left of the first column header. Working in all versions -- Regards Ron de Bruin http://www.rondebruin.nl "guyd" wrote in message ... I am trying to highlight all of the information in my speadsheet using ctrl+A. When I press ctrl+a, howeveer, only a portion of my data is highlighted. What can I do to make this function work the way it's supposed to? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using ctrl+A
I did as you suggested: ctrl+A once and then ctrl+A a second time. The
highlighted area stayed the same. "Zack Barresse" wrote: It is a toggle. You hit it once and it will select the Current Region. Hit it again and the entire sheet will be selected (the cells). HTH -- Regards, Zack Barresse, aka firefytr "guyd" wrote in message ... I am trying to highlight all of the information in my speadsheet using ctrl+A. When I press ctrl+a, howeveer, only a portion of my data is highlighted. What can I do to make this function work the way it's supposed to? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using ctrl+A
How about Ctrl+Shift+[Space]?
guyd wrote: I did as you suggested: ctrl+A once and then ctrl+A a second time. The highlighted area stayed the same. "Zack Barresse" wrote: It is a toggle. You hit it once and it will select the Current Region. Hit it again and the entire sheet will be selected (the cells). HTH -- Regards, Zack Barresse, aka firefytr "guyd" wrote in message ... I am trying to highlight all of the information in my speadsheet using ctrl+A. When I press ctrl+a, howeveer, only a portion of my data is highlighted. What can I do to make this function work the way it's supposed to? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using ctrl+A
That acts as the same shortcut key combination. Weird, I know.
-- Regards, Zack Barresse, aka firefytr "Lori" wrote in message ps.com... How about Ctrl+Shift+[Space]? guyd wrote: I did as you suggested: ctrl+A once and then ctrl+A a second time. The highlighted area stayed the same. "Zack Barresse" wrote: It is a toggle. You hit it once and it will select the Current Region. Hit it again and the entire sheet will be selected (the cells). HTH -- Regards, Zack Barresse, aka firefytr "guyd" wrote in message ... I am trying to highlight all of the information in my speadsheet using ctrl+A. When I press ctrl+a, howeveer, only a portion of my data is highlighted. What can I do to make this function work the way it's supposed to? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CTRL +S highlights cells, won't save | Excel Discussion (Misc queries) | |||
| How do I change the end cell (Ctrl end) in a excel spreadsheet? | Excel Worksheet Functions | |||
| Does Ctrl + F works in protected file with formulas? | Excel Worksheet Functions | |||
| Ctrl "C"...CTRL "V" | Excel Worksheet Functions | |||
| Ctrl Page Down/Up | Excel Discussion (Misc queries) | |||
Linear Mode
