98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course london - Limitation on number of rows
microsoft excel course london - Limitation on number of rows
Resolved · Low Priority · Version Standard
Fri 12 Jan 2007, 15:08Delegate Rob said...
Rob has attended:
Excel Advanced course
Limitation on number of rows
A have a large amount of transaction data which I wish to manipulate but I cannot fit it into the 65536 rows available in Excel - is there any way of adding further rows beyond the 65536 already there?
Fri 12 Jan 2007, 16:37Trainer Richard said...
RE: Limitation on number of rows
Excel cannot handle more data than the max rows. The next step would be to use MS Access, as it can handle more data.
Sat 13 Jan 2007, 10:08Trainer Pete said...
RE: Limitation on number of rows
I agree with Richard, Excel up to version 2003 only has 65,536 rows, and perhaps Access is the way to go, however if you must use Excel, then version 2007 has many more rows, in fact I got up to nearly 200,000 rows and gave up, my scroll wheel was getting too hot.
Sat 13 Jan 2007, 10:08Trainer Pete said...
RE: Limitation on number of rows
I agree with Richard, Excel up to version 2003 only has 65,536 rows, and perhaps Access is the way to go, however if you must use Excel, then version 2007 has many more rows, in fact I got up to nearly 200,000 rows and gave up, my scroll wheel was getting too hot.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Change the Default Width of All Columns in Excel 2010If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how: |
