Maximum Rows/Columns in an Excel Worksheet
-
Hi all, Apologies if this is a little off-topic for this board, but does anyone know where I can find out the maximum number of rows and columns allowed in an Excel spreadsheet. For once, Goggle isn't being particularly helpful. TIA, Pete
Well, to answer my own question: http://support.businessobjects.com/library/kbase/articles/c2000454.asp however, I'd like to get an 'official' description from Microsoft, to satisfy my boss if nothing else...
-
Hi all, Apologies if this is a little off-topic for this board, but does anyone know where I can find out the maximum number of rows and columns allowed in an Excel spreadsheet. For once, Goggle isn't being particularly helpful. TIA, Pete
Unless they changed in the latest version here are the Maximums. Rows: 65536 Columns: 256 You can have many sheets, but each sheet cannot contain more than this. This is annoying when one wants to import a 100,000 lines of invoices coming from an external prog for analysis reasons. Unfortunately i dont have an official link for you. Hope this helps.