MegaSack DRAW - 6pm Christmas Eve - LIVE on our YouTube Channel
As far as I can tell, the max number of rows and columns is preset. There's 65,000 rows yet only 280-odd columns (up to IV). Is there a way of adding more columns? Cheers!
256 - I believe & no
if you need more columns, why? buy Excel 2007, or try and create lookups between Worksheets.
[i]if you need more columns, why? buy Excel 2007, or try and create lookups between Worksheets. [/i]
A girl at work's trying to do a holiday chart with all 365 days going across - it's not happening for her though! As resident Excel 'expert' I'm meant to know how to sort it out......
Use the columns for months & the rows for days or split it into 2 spreadsheets
i would have thought it would make more sense to run days as row headings and i am guessing staff names? as column headings, then run over a number of worksheets if you have more than 256 employees?
Bin out the weekends?
Bin out the weekends?
I take it maths is not your strongest subject? 😀
I made the (admittedly large)assumption that it was a mon-fri job
so binning out 2 days a week that woudnt be used - about 100 less columns
should fit in less than 280 columns
HTH!
should fit in less than 280 columns
indeed it would, unfortunately there's only 256 available 🙂
I assumed the OP was correct 🙂
you are stuck with 256
or buy 2007 which is unlimited
Standard request from secretaries trying to do tables in Excel instead of Word 🙂
Turn it round the other way and use the rows.
Or use Windows Excel Fisher Price 2007 for Dummies 😉
Bit of a longshot, but...
I know if you want to run a pivot table with more than 65000 rows you can link to a csv file and run it from that.
There might be a similar workaround which applies to [b]columns[/b] and could be used in a non-pivot table situation?
That said... I'm not sure how exactly you'd store the information in csv format without using Excel 2007 and saving it as a csv file!
