CTRL+SHIFT+*
Selects the current region around the active cell (the data area enclosed by
blank rows and blank columns).

CTRL+SHIFT+DownArrow
Selects the cells in the same column with data

--
Jacob (MVP - Excel)


"Joe" wrote:

Could anyone tell me what is the shortcut to select the used up cells in a
column?
--
Failing to plan is planning to fail