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.

if you need more columns, why? buy Excel 2007, or try and create lookups between Worksheets.

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 columns 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!