combine two excel requirements

Posted on 2014-01-13
Medium Priority
Last Modified: 2014-01-14
Question by:rgb192
  • 2
  • 2
LVL 19

Expert Comment

ID: 39777033
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
LVL 26

Expert Comment

ID: 39777054
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?

Author Comment

ID: 39777069
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
LVL 26

Accepted Solution

pony10us earned 2000 total points
ID: 39777133
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.

Author Closing Comment

ID: 39780814
now rows are short


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question