rgb192

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

I do not want collapsed columns

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

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

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

ASKER

This worked. Thanks.

- Right click on col A

- Select "unhide"