Avatar of rgb192
rgb192
Flag for United States of America asked on

using columns a-k, please expand so I can see all the data in column

windows excel 2007

I do not want collapsed columns
Microsoft Excel

Avatar of undefined
Last Comment
rgb192

8/22/2022 - Mon
Angelp1ay

- Click just left of col A to select the whole sheet
- Right click on col A
- Select "unhide"
ASKER CERTIFIED SOLUTION
helpfinder

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Steven Carnahan

Method 1:

1. Highlight column A
2. Place cursor on line between "A" and "B" so that you have the arrow pointing both left and right
3. While holding down mouse button drag to right until you have desired width

Method 2. (similar to Method 1)

1. Highlight column A
2. Place cursor on line between "A" and "B" so that you have the arrow pointing both left and right
3. Double click mouse to automatically expand the width of column A to length of cell with max data

Method 3. (same as method 2 except does all desired columns at same time)

1. Highlight column A through desired column (K in your case)
2. Place cursor on line between "A" and "B" so that you have the arrow pointing both left and right
3. Double click mouse to automatically expand the width of all desired colmuns to length of cell in each column with the max data

Method 4. (will adjust all columns)

1. Click small square above "1" and left of "A" (this will highlight entire sheet)
2. Dobule click mouse to automatically expand/reduce the width of all columns to length of cell in each column with the max data
rgb192

ASKER
This worked.  Thanks.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck