That won't affect ROWS...

In article ,
"Don Guillett" wrote:

manually
select the first columnhold shift keyselect last
columnformatcolumnwidth

in a macro

Sub setcolumnwidth()
Columns("a:j").ColumnWidth = 20
'or
'Range(Cells(1, 1), Cells(1, 10)).ColumnWidth = 20
End Sub