Setting row height for all rows

**anjanesh** · 05-03-2006, 06:00 AM

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

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

Thanks

Pete_UK · 05-03-2006, 06:10 AM

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** · 05-03-2006, 08:25 AM

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

Patricia Shannon · 05-03-2006, 11:00 AM

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

"anjanesh" wrote:

>
> Ah...thanks - btw, how do I specify 17px and not 17pts ?
>
>
> --
> anjanesh
>
> Freelance Developer
> ------------------------------------------------------------------------
> anjanesh's Profile: http://www.excelforum.com/member.php...o&userid=27132
> View this thread: http://www.excelforum.com/showthread...hreadid=538377
>
>

Gord Dibben · 05-05-2006, 02:50 PM

12.75 pts equals 17 pixels(approx)

Gord Dibben MS Excel MVP

On Wed, 3 May 2006 07:25:55 -0500, anjanesh
<[email protected]> wrote:

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