Select all data, multiple rows
 

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

Hi George

When holding the Ctrl key click on the column headers

--
Regards Ron de Bruin
http://www.rondebruin.nl


"George Wilson" wrote in message ...
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

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

"Ron de Bruin" wrote:

Hi George

When holding the Ctrl key click on the column headers

--
Regards Ron de Bruin
http://www.rondebruin.nl


"George Wilson" wrote in message ...
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

Hi George

Only with a macro as far as I know.
If you want that post back

--
Regards Ron de Bruin
http://www.rondebruin.nl


"George Wilson" wrote in message ...
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

"Ron de Bruin" wrote:

Hi George

When holding the Ctrl key click on the column headers

--
Regards Ron de Bruin
http://www.rondebruin.nl


"George Wilson" wrote in message
...
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

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



U¿ytkownik "George Wilson" napisa³
w wiadomo¶ci ...
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

"Ron de Bruin" wrote:

Hi George

When holding the Ctrl key click on the column headers

--
Regards Ron de Bruin
http://www.rondebruin.nl


"George Wilson" wrote in
message ...
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

I think that will work, thank you.
George

"Krum" wrote:

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



U¿ytkownik "George Wilson" napisa³
w wiadomo¶ci ...
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

"Ron de Bruin" wrote:

Hi George

When holding the Ctrl key click on the column headers

--
Regards Ron de Bruin
http://www.rondebruin.nl


"George Wilson" wrote in
message ...
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

"George Wilson" wrote in message ...
I think that will work, thank you.
George

"Krum" wrote:

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

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.