Need more columns

  • Thread starter Thread starter Nick
  • Start date Start date
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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)
 
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
 
Hi Thomas!

Yes!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top