Row Height/Column Width

[klynshoe]

Is there a way to change all the rows heights and/or column widths in a worksheet? The only way I know how is by selected the rows I wish to change and right-clicking.

USING EXCEL 2007

 

[jfish1288]

If you want to change all of the row heights and columns widths to a specific size you can use

Sub resize()
Range("A:IV").ColumnWidth = 8.43
Range("A1:A65536").RowHeight = 12.75
End Sub

Change 8.43 and 12.75 to whatever size you want.

Or if you just select the rows/columns you are interesed in you can autofit all of them by double clicking on the dividing line between the last row/column of intrest and the next one

 

[HalfAce]

Without a macro?
Well, it's the same as you're used to, except that you can select the entire sheet and manually do them all at once.
(Select the 'button' at the top left, above row1 and to the left of column A) and do your manual thing.

or using a macro...

With Cells
  .RowHeight = 5
  .ColumnWidth = 5
End With

Hope it helps.

 

[klynshoe]

Yes I would prefer to not do a macro. However when I select the entire worksheet and right click, the option to change the row height and column width is not available.

 

[HalfAce]

Select the entire sheet (as above) and, with the whole sheet selected, move your mouse down to one of the row headers before right clicking.
Then move it to one of the column headers & right click to do the columns.

That help?

EDIT:
Guess I should point out I'm on xl 03 here. My 07 is at home but I assume it works the same way for this.

 

[klynshoe]

Perfect!! I knew it had to be something simple. LOL.

Thanks!

 

[HalfAce]

Most welcome. Glad it helped.