• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

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

windows excel 2007

I do not want collapsed columns
0
rgb192
Asked:
rgb192
1 Solution
 
Angelp1ayCommented:
- Click just left of col A to select the whole sheet
- Right click on col A
- Select "unhide"
0
 
helpfinderIT ConsultantCommented:
just point your mouse cursor on the border of the columns so cursor will change and double-click

01
0
 
pony10usCommented:
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
0
 
rgb192Author Commented:
This worked.  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now