Can I have more than 256 columns?
I realize that might be a stupid question, but it seems odd that "Excel" would allow you to have 65,536 rows, but only 256 columns. I'm nearly out of columns, and would prefer to keep everything on one sheet with the current lay-out.
Thank you in advance for your help.
Not in Excel 2003.Originally Posted by taketwo
Options are:
- Multiple sheets
- Upgrade to 2007
Q: How many rows are using?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Thank you, JB.
I currently have 207 rows, and am nervous that I will soon be over the limit.
Last edited by taketwo; 08-03-2009 at 08:26 PM. Reason: Thanking people is important.
ive got loads of columns im not using want to buy some? lol
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
207 rows doesn't put you anywhere near the limit of 65535 rows in Excel 2003, or 1+ million rows in Excel 2007.
I'm guessing you meant 207 columns? I think JB wanted to know how many rows you had to see if perhaps your data could be switched. Have your current column headers going down the left side of the worksheet in rows, and have your current rows go across the top in columns. If you have more than 255 rows of data, this obviously won't work and your only options are to upgrade to 2007 or span your data across multiple worksheets or workbooks.
Add mind-reading to moderator skill-set...hehe.That's exactly what I was thinking.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Yup, exactly what I meant, I have 207 columns. Sorry for the confusion.
As for transposing the data, I have several thousand rows, so that won't work.
How many columns and rows does "Excel 2007" have?
According to http://visio.mvps.org/Excel_2007.htm, there are several enhancements to the limitations of rows, columns, memory, colors, etc. in Excel 2007.
I've been using Excel 2007 for several months now, and having over 1 million rows and 16,000+ columns has really come in handy.
lots!
1,048,576 rows by 16,384 columns
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Caution about using anything beyond Excel 2003 standards in Excel 2007:
If you share your file with other users that don't have Excel 2007, it won't work as they won't be able to see any data beyond 256 columns x 65535 rows.
In order to use the full Excel 2007 worksheet (16 thousand columns x 1 million rows) it needs to be saved in a new format (.xlsx, .xlsm, etc.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks