Is it poss to resize sheet to "400 col by 2000 rows

keithkemble

Board Regular
Joined
Feb 15, 2002
Messages
160
I would love to be able to resize one of my sheet to approx 400c x 2k rows.
If it is, how?, and would the code reside with in the file as I have to distribute file within the org.
kk
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Hi--

Try transpose and so different way of working, i have been forced to do this before -

Else -- split over 2 or more sheets

HTH
Rdgs
==========
Jack
 
Upvote 0
Thanks JAck,
I do split over many sheets. It is that I am having hassle in trying to substitute a variable in a cell reference on a nother page.
Hopefully will post my problem later
 
Upvote 0
How hard have you tried to reduce the column count? Are a lot of borders turned on?

Is it possible that use of right-justify and left-justify could achieve psuedo-columns for you? How many of your columns end up being merged together?
 
Upvote 0
I cannot transpose as I require 20000 rows plus 400 cols. Others will be using the model and therefore simplicity is the key

I have already split the sheets as is the norm.
If any one find a code please advise.
 
Upvote 0
Our IT dept do not want to pay for licences for 450 people.

Although we are 95 % Bill Gates dbases are frowned upon As we have our own IT dept. (Laugh I nearly died) :)
 
Upvote 0
Hi Keith --

I agree but did not want to say as Barrie has, your streatching Excel Shes lovley and sexy and all but suffers if you make her carry to much shopping.

She will be just fin if you split as you have but then its power of your PC..

Access has limits as well so its a trade of, i dont feel Access can allow the ciustom (whatever you like) as Excel will. VBA in Access is just as good, but i know no one that does this..

Good luck, pacic if Excel grinds to a halt.

TOP tip--- make regula back up in case it suffers heart attack! :(

HTH
Rdgs
==========
Jack :)
 
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,136
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top