View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ed Ed is offline
external usenet poster
 
Posts: 279
Default Fitting cell to typed word

I think that did it
Thank You

"Dave Peterson" wrote:

I just read David's response.

If your words in that column don't contain any embedded spaces, maybe you could:

Select the column
edit|Replace
what: (spacebar)
with: (leave blank)
replace all



Dave Peterson wrote:

Do you have any hidden rows that contain longer text?

How about long headers?

Ed wrote:

Excel 2002, I have opened a data base the cells have been set for 25 but my
names are only 6 letters long. When I do a column width adjustment it still
stays at 25.
I can manually shrink each cell by clicking on the cell and placing my
cursor at the end of the word and delete the blanks. But is there a way to do
this for the complete data base?


--

Dave Peterson


--

Dave Peterson