Setting row height for all rows

[anjanesh]

I got an excel file that has some row height more than 17px - most fo
them (default I think) are 17 pixels.

How do I set the row height for all rows to 17px ?

Thanks

 

[Pete_UK]

Highlight all the rows (click on the box at the intersection of the row
and column identifiers) then Format | Row | AutoFit (or you could
select Height and specify 17pt).

Hope this helps.

Pete

 

[anjanesh]

Ah...thanks - btw, how do I specify 17px and not 17pts ?

 

[Patricia Shannon]

If you know how to write a simple VBA macro, you can find the conversion.
In the VBE editor, look at Help for pixels.

 

[Gord Dibben]

12.75 pts equals 17 pixels(approx)


Gord Dibben MS Excel MVP