Adjusting row heights and column widths to align with another sheet

[Raj]

Hi,

A workbook has sheets containing printable reports. All have identical
columns and widths. After experimenting, I have arrived at an ideal
row heights and column widths for one of the sheets. I now need to
adjust the other sheet to the same heights and widths. Any way to do
this using VBA or through the user interface?

Thanks in advance for the help.

Regards,
Raj

 

[OssieMac]

It seems like this is a one off so all you need to do is select the worksheet
with the correct column widths and row heights then hold the Ctrl key while
you click on the other worksheet tabs. (this selects multiple worksheets).

Alternatively holding the Shift key and select the last sheet and all sheets
between the initial and last are selected.

Now just select each column in turn and then Format -> Column -> Width and
click OK to accept the displayed width. Same for rows.