Fitting cell to typed word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
No Hidden headers or rows that contain text. Just blank spaces after each
word, not allowing me to shrink the cell. But I can go to each cell and
delete the blank spaces and it will work. But I need a way to do the complete
data
 
I think that did it
Thank You

Dave Peterson said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best-fit column based on a cell range 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
fixed TextBox with Shrink to fit text 1
Resize cell to fit picture 3
Formula not recognizing reference to "" in IF statement 2
Why does some text wrap and fit and other doesn't 3
Can you keep text from one cell showing over the next cell? 3
How to make the cursor stay in the cell when entering data. 2

Back
Top