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

combine two excel requirements

0
rgb192
Asked:
rgb192
  • 2
  • 2
1 Solution
 
helpfinderCommented:
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
 
pony10usCommented:
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
 
rgb192Author Commented:
now rows are short

thanks
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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