Formatting cell size

[datadummy]

I am looking for advice on formatting cells for height and width. I have tried selecting the whole worksheet and then using the cell Autofit functions in the format section to no avail. I have multiple columns that are to narrow while others are to wide. Any advice on adjusting these without addressing each cell manually?

 

[dreid1011]

Have you tried selecting the entire sheet then double-clicking on a column or row divider at the top/left of the sheet? (the grey bars with column/row labels)

 

[datadummy]

Yea to no avail, I am wondering if the fact that wrap text has been applied to the entire sheet is factoring in. I'm at a loss.

 

[dreid1011]

That could be. When I copy/paste data from threads here, I use this little snippet to clean it up because the forum formatting is goofy when pasted into excel.

Sub Macro1()
'
' Macro2 Macro
'
'
    ActiveSheet.UsedRange.Select
    With Selection
        .Font.Name = "Calibri"
        .Font.Size = 11
        .Font.ColorIndex = xlAutomatic
        .Interior.Pattern = xlNone
        .EntireColumn.AutoFit
        .HorizontalAlignment = xlGeneral
        .WrapText = False
        .Orientation = 0
        .MergeCells = False
    End With
End Sub

 

[datadummy]

Awesome that did the trick, thanks!!!

 

[dreid1011]

You're welcome .