View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Adjusting row heights and column widths to align with another shee

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.

--
Regards,

OssieMac