ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you select all text/data within all the cells of a column? (https://www.excelbanter.com/excel-discussion-misc-queries/214308-how-do-you-select-all-text-data-within-all-cells-column.html)

VisionsIC

How do you select all text/data within all the cells of a column?
 
that's the question:

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

smartin

How do you select all text/data within all the cells of a column?
 
VisionsIC wrote:
that's the question:

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


Ctrl+Space?

Pete_UK

How do you select all text/data within all the cells of a column?
 
Click on the column identifying letter at the top of each column.

Hope this helps.

Pete

On Dec 20, 1:07*am, VisionsIC
wrote:
that's the question:

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



RagDyeR

How do you select all text/data within all the cells of a column?
 
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!
================================================== ===

"VisionsIC" wrote in message
...
that's the question:

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




All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com