what is maximum number of colums in worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to make a timeline for all of 2005, Jan-Dec. I also need to
include 6 colums of -data related to each day on the timeline. I now have to
worksheet dividing the year in-half, with some overflow added to each
section, Jan-Aug & Jun-Dec.

Can I get all of this on one worksheet?
 
365 days at 6 columns per day gives you in excess of 2000 columns which is
nearly 10 times the maximum number of columns you can have (256 is the max).
You will need to consider transposing your data, albeit timelines don't
always work nicely when vertical.
 
The max number of columns is 256

--
Ken Russell

(e-mail address removed)
Remove yourhat to reply by e-mail
..
 
256 columns maximum.

You do the arithmetic..........

Have you thought about laying out in rows?

There are 65,536 of those.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

weeks in a month 1
Still trying to average 4 worksheets and having formula problems 3
display cell content based on date criteria 2
Excel: show the row when either one of the columns is>0 2
reverse the order of data in a column.(1,2,5 goes to 5,2,1) 2
Receiving #VALUE! error for my average formula 2
if cell in other worksheet meets criteria, then leave blank. 1
maximum number of rows in pivot table data 2

Back
Top