Need more columns

N

Nick

Hi

I am making a financial model that needs >22 years of
monthly data. Since Excel only has 256 columns it won't
all fit across, does anyone have any ideas what i could do
to make it better. Not really keen on replicating stuff
down the page or over sheets.

Thanks heaps
Nick
 
N

Norman Harker

Hi Nick!

Probably the best way is to set time on the vertical scale. Sorry if
the truth hurts!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
B

Bob Phillips

Nick,

You could do as Norman says, and transpose the data, or you could spread
across separate spreadsheets (say 5 or 10 years per sheet), or you need to
look at another product. I can't see any other options.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

Guest

Hello,

I am having the same problem as well for my research. I
am wondering if Excel 2003 has the column and row
limitation as in Excel 2002.

Thomas
 
N

Norman Harker

Hi Thomas!

Yes!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top