More that 256 Colums?

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
 
F

Frank Kabel

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
 
J

John Wilson

Kevin,

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

John
 
N

Norman Harker

Hi Kevin!

Sorry but 256 columns is the limit.

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

Guest

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
 
D

Dave Peterson

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???)
 
Top