combine two excel requirements

LVL 1
rgb192Asked:
Who is Participating?
 
pony10usConnect With a Mentor Commented:
Try following Option 4 that I gave in question #2 only double click between "1" and "2" to auto-adjust the height of all rows after you have the width adjusted.
0
 
helpfinderIT ConsultantCommented:
do the combination of our answers - hide unneccessary columns and fit cell width to text in it. Here you can have problem because if text in your cells (columns) is too long you have to use Excel zoom feature or set smaller letters or use higher display resolution or bigger screen
0
 
pony10usCommented:
In the first question you are talking about only using columns A-D and the second you are expanding this to A-K.

Are you looking for something that will do this automatically (a macro or VBA) performing both functions at the same time?
0
 
rgb192Author Commented:
in this question, a-d (because e-z is hidden and empty)

column b
has alot of data
so when I expand column b
by clicking and dragging
then column b is on one line

but there is alot of height so I can only see 8 rows on my screen
0
 
rgb192Author Commented:
now rows are short

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.

All Courses

From novice to tech pro — start learning today.