More that 256 Colums?

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Hello,

I'm making a calender for the fiscal year and I would
like to go go fm Apr to Mar as per. The problem I'm
having is that it'll only allow me to Sept or so. How
can I add more colums to the worksheet/or can I?

Regards,
Kevin
 
Hi Kevin

sorry to say but there is no way to extend the column number. 256 is
the maximum. So one way is to split your calendar on two worksheets

Frank
 
Kevin,

256 Columns is the limit. No physical way around it.
You might want to try a worksheet for each month.

John
 
Hi Kevin!

Sorry but 256 columns is the limit.

--
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.
 
Kevin,

From my experience, column IV is it.

You can't go any further than this.

It's kind of gradifying, however, when you are working
with a spreadsheet and you've gone as far as it will go.

Kind of like that one commercial where the guy get's to
the end of the internet.

Dennis
 
Since you can't exceed the 256 column limit, maybe you can transpose your
calendar--put the original rows in the columns and the original columns in the
rows.

(Or maybe use multiple worksheets???)
 
Back
Top