Link to home
Start Free TrialLog in
Avatar of rgb192
rgb192Flag 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
Avatar of Angelp1ay
Angelp1ay
Flag of United Kingdom of Great Britain and Northern Ireland image

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

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 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
Avatar of rgb192

ASKER

This worked.  Thanks.