View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Reb Reb is offline
external usenet poster
 
Posts: 13
Default How to copy row height?

This might work for you:

Select the row(s), either contiguous or non-contiguous, that you want to
change.
Place cursor on the bottom edge of one of the selected row headers, hold
down the mouse btn and drag to the height you want (indicated on the pop up)
and release the mouse btn. Selected row(s) should be at the indicated height.

" wrote:

Errata....

I wrote:
Reb wrote:
Use Format Painter.
Select row, set row height using format menu, dbl clk Format Painter, select
row(s) to apply height.


That did not copy row height, whether I single-click or double-click
FP.


My bad! I selected a cell, not the entire row. Nonetheless, FP does
copy other format specifications. As I noted previously, I do not want
that. I simply want to copy row height, just as I can copy only column
width.