Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
that's the question:
In Excel 2007 - How do you select all text/data within all the cells of a column? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to select certain cells in a column ? | Excel Discussion (Misc queries) | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
Shortcut to select column with data in previous column | Excel Discussion (Misc queries) | |||
Column Width for a select # of cells | New Users to Excel | |||
In a column of text data, how do I delete random cells that have . | Excel Discussion (Misc queries) |