![]() |
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? |
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? |
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? |
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 06:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com