format cells


G

Guest

How can I format cells so that there is the same distance from the text in
every cell? Some cells may be one line of text while others may be 5 lines
of text. I would like to find a way to not have to go back and manually
change the row heights. Seems like there would be some way to get this done.
I sure can't figure it out.
 
Ad

Advertisements

B

boosbrde

If you are looking to format the row height, go to format, select row,
then select height and type in the number. You may have to experiment
with it a couple of times to get what you are looking for. Also, if
you go to the top left corner and select the whole page, right click,
and select format cells, on the "Alignment tab you can select to
center the information in the cells, using the horizontal and vertical
boxes.

Deb
 
Ad

Advertisements

G

Gord Dibben

Would be easier and more accurate if OP was to select the column in question and
Format>Row>Autofit.

Then format the cells to center vertically if desired.

Note to OP..........row height is a property of the entire row so you cannot
have varying cell heights across a row, just down a column.


Gord Dibben MS Excel MVP
 

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

Top