Quick way to expand all columns to show all data?

  • Thread starter Thread starter david.karr
  • Start date Start date
D

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?
 
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,

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

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?
 
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.
Click to expand...

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?
 
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.
 
Back
Top