Adjusting column widths to fit text plus extra space

[Jennifer Murphy]

I can get Excel to adjust one or more columns to fit the data by
selecting the columns and double-clicking on one of the column header
borders.

The result is the smallest possible width for the existing data. This
is a little too tight for optimum viewing. Is there a way to tell
excel to choose a width that is slightly wider?

In Word, there is a *Cell Margin* setting for tables. Is there
anything similar in Excel?

 

[Gord Dibben]

Column Auto-width has no cell margins parameters that can be set.


Gord Dibben MS Excel MVP

 

[Bruce Sinclair]

Column Auto-width has no cell margins parameters that can be set.

... an obvious work around ... take the longest entry in the column, copy it
to another row, add a space in front and behind (or 2 each perhaps?), then
use autowidth ? Could probably do this automagically, and could hide the row
if you don't want to see it ?
Or perhaps an apparently empty cell actually containing a number of spaces
that suits the viewer ?

 

[GS]

Another way...

With Columns(?).EntireColumn
.IndentLevel=2: .AutoFit: .IndentLevel=1
End With

...which leaves ample space to either side of the contents without
upsetting alignment settings.