rgb192
asked on
combine two excel requirements
Combine two windows excel 2007 questions.
only want to see four columns
https://www.experts-exchange.com/questions/28337119/only-want-to-see-4-columns-because-that-is-all-I-am-using.html
AND expand those columns to show all the data in columns.
https://www.experts-exchange.com/questions/28337157/using-columns-a-k-please-expand-so-I-can-see-all-the-data-in-column.html
only want to see four columns
https://www.experts-exchange.com/questions/28337119/only-want-to-see-4-columns-because-that-is-all-I-am-using.html
AND expand those columns to show all the data in columns.
https://www.experts-exchange.com/questions/28337157/using-columns-a-k-please-expand-so-I-can-see-all-the-data-in-column.html
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
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?
Are you looking for something that will do this automatically (a macro or VBA) performing both functions at the same time?
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
now rows are short
thanks
thanks