Setting Column Width

Copper Contributor

I am trying to create a spreadsheet that will create vertical strips of paper that I will be able to print out and use for a project.  I need each strip to be 0.34".  When I select the entire worksheet and format all columns to 0.34", click OK and then to verify, I right click on the header of a column to check the width it is saying 0.33".  If I click OK, then re-check, it says the column is now 0.32".  Does anyone know why Excel continues to resize the column rather than keeping it at 0.34"?

1 Reply
maybe try with VBA....

Sub Adjust_column_width()
With Columns("A:A")
.EntireColumn.AutoFit
If .ColumnWidth > 10 Then
.ColumnWidth = 10
End If
End With
End Sub

I would be happy to find out if I could help.

Nikolino
I know I don't know anything (Socrates)