Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 915
Default 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?
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default 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?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to select certain cells in a column ? Mark246 Excel Discussion (Misc queries) 1 February 25th 08 11:08 PM
Macro to select cells in column enter data then press enter NP New Users to Excel 1 February 20th 08 05:21 PM
Shortcut to select column with data in previous column TJAC Excel Discussion (Misc queries) 1 July 10th 07 06:12 PM
Column Width for a select # of cells April New Users to Excel 1 July 7th 05 10:06 PM
In a column of text data, how do I delete random cells that have . Minivann Excel Discussion (Misc queries) 2 January 26th 05 10:07 PM


All times are GMT +1. The time now is 04:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"