How do you select all text/data within all the cells of a column?

[VisionsIC]

that's the question:

In Excel 2007 - How do you select all text/data within all the cells of a
column?

 

[Pete_UK]

Click on the column identifying letter at the top of each column.

Hope this helps.

Pete

 

[RagDyeR]

If you want to *only* select text/data, and *not* empty cells,

Click on the letter at the top of the column,
then hit <F5>,
then click on "Special",
and then click "Constants",

then make sure that only "Text" is checked below,
then <OK>.

If you also wish to include numbers, since you did say "data",
make sure that's checked also.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

that's the question:

In Excel 2007 - How do you select all text/data within all the cells of a
column?