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