Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a quick way to show selected columns (not using hide) Anhlyss Excel Discussion (Misc queries) 1 February 18th 10 07:52 PM
Excel: How do I auto expand Cells to show all the wrapped text? DonnaTypes01 Excel Worksheet Functions 5 November 25th 08 04:38 PM
need to expand an Excel cell for mail merge contents to show Mrs_Oz Setting up and Configuration of Excel 1 May 18th 08 06:28 AM
Show data in columns flyer27 Excel Discussion (Misc queries) 1 March 13th 07 06:56 PM
Expand columns valiantria Excel Worksheet Functions 2 January 11th 07 10:05 PM


All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"