Select all data, multiple rows

G

George Wilson

Currently I can select all data in an Excel column by placing the cursor in
the top cell and then pressing Control+Shift+Down arrow. Is there a way to
select the uppermost cell of multiple columns and perform this procedure? I
would like to be able to choose A1, C1 and E1 and use a similar keyboard
shortcut to select all the data, is there a shortcut for this?
TIA
George
 
G

George Wilson

Selecting the header highlights all 65535 cells in the column, is there a way
to select only data as the operation I described above will do?
George
 
K

Krum

1. holding the ctrl key select headers of columns
2. ctrl + g
3. choose "special"
4. choose "constants" or "formulas" depending on what kind of data you have
in these columns

regards
Krum
 
G

George Wilson

I think that will work, thank you.
George

Krum said:
1. holding the ctrl key select headers of columns
2. ctrl + g
3. choose "special"
4. choose "constants" or "formulas" depending on what kind of data you have
in these columns

regards
Krum
Click to expand...
 
H

Herbert Seidenberg

George Wilson said:
I think that will work, thank you.
George
Click to expand...

Krum's method will work if there is no data below the desired data.
Otherwise do this: Give your data vectors unique names, then select
the desired names in the NAME box, holding down CTRL. Alternately, go
to the GO TO box and type in the desired names in the REFERENCE box,
separated by commas.
A faster way to select one data vector is to place the cursor on the
bottom edge of the first cell, hold down the SHIFT key and double
click. Works in other directions too.
 
Top