row height

[paascal]

hello,

i would like to set row height on ALL cells : 1 lined and multilined... i want to have more spacing between lines to make it easier to read. home, cells, format works fine for a cells that has only one line but looks like **** if the cell is multilined. is there a way to make the cells so much bigger (height wise) than the shown text?

this way i wouldnt have to go resize all the cells that are multi lined

thanks

[Xer2]

Click the circled button once to select all cells and either:
1: Click the blue line and drag down to the desired height
2: Double-click the blue line to auto-fit all cells.

SelectAll.JPG

If this is not what you need, please explain further what your needs are.

[paascal]

default row heigt seems to be 21pixel, i want it to be 33 and i want excell to remember when i go and double click on the blue line you are talking about...

right now it always sets it back to 21 when i double click on the line.

so that when i select all cells and double click the blue line, single lines are 33 pix heigh and the lines with more thant 2 lines adjust using the 33 pix spacing (height above and under lines.

[Xer2]

In that case, do a select all then right click on the blue line, select row height and enter 33.00.

Row Height.png

[paascal]

In that case, do a select all then right click on the blue line, select row height and enter 33.00.

Attachment 175571

if i do this all lines will be 33... and excell wont remember that 33 is the new default row height. i want the cells that have 1 line to be 33 and the ones that have more than one line to keep the 33 row height spacing.