View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Daryl S Daryl S is offline
external usenet poster
 
Posts: 135
Default Quick way to expand all columns to show all data?

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.
--
Daryl S


"david.karr" wrote:

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