Quick way to expand all columns to show all data?

[david.karr]

I often open newly-created spreadsheets where the data in columns is
wider and taller than it displays initially. I then drag select all
the column headers and double-click between the first and second
column header. That expands the width of all column displays to show
all the data, widthwise. I then drag select all the row headers and
double-click between the first and second row header. That expands
the height to show all data.

Phew. Is there an easier way to do this?

 

[Bernie Deitrick]

David,

Click the box above and to the left of cell A1, and that will select all the
columns and rows - no dragging required.

HTH,
Bernie
MS Excel MVP

 

[david.karr]

David,

Click the box above and to the left of cell A1, and that will select all the
columns and rows - no dragging required.

Ok. that helps. I then have to double-click on the A-B separator and
the 1-2 separator? I don't suppose there's a shortcut that does that,
or even better, combines that with selecting all rows and columns?
Doesn't that seem like something people would do a lot?

 

[Bernie Deitrick]

David,

Run a macro from a custom button:

Sub FitCells()
Cells.EntireColumn.AutoFit
Cells.EntireRow.AutoFit
End Sub


One click....

HTH,
Bernie
MS Excel MVP

David,

Click the box above and to the left of cell A1, and that will select all
the
columns and rows - no dragging required.

Ok. that helps. I then have to double-click on the A-B separator and
the 1-2 separator? I don't suppose there's a shortcut that does that,
or even better, combines that with selecting all rows and columns?
Doesn't that seem like something people would do a lot?

 

[Daryl S]

David -

Just click in the top-left corner to select all cells in the worksheet,
then double-click the between columns A and B and double-click between rows 1
and 2.