automatic cell resize

  • Thread starter Thread starter xman123
  • Start date Start date
X

xman123

In my excel spreadsheet, i type a lot of information into individua
cells. Most of the time this information carys on to anonther line an
i have to resize the cell by hand if i want the information to print.

How can i create a macro to resize these cells automatically? Pleas
help
 
Double click on the column separator at the top. Column will resize
automatically.
Or you can chooose Format/Columns/AutoFit Selection

Hope it helps
 

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

Resize cell to fit picture 3
Cells ignore Wrap Text formatting! 2
PivotChart resizing problem 2
Text doesn't print out the same as in the print preview 2
Resizing merged / wrapped cells. 2
Combo box resize with cell? 3
Comments boxes resizing 3
click on multiple cells 3

Back
Top