Forum Discussion
Re configuring an excel sheet for less columns and more rows
An Excel worksheet has 1048576 rows and 16384 columns. This is hard-coded and cannot be changed. So you'll have to keep on splitting the data into multiple sections.
Thank you Hans, maybe Microsoft would consider making Excel more flexible and allow the user to define the boundaries, I did read that a work sheet is only saved using the formatted cells to save memory so maybe there is a mechanism!? It's a very inefficient method to work through these sheets and re assemble the whole thing at the end. I have made tools in Python before , so back to the learning curve to make this a straight forward exercise that others can make use of without in depth knowledge.
You can submit a suggestion to Microsoft from within Excel, by selecting File > Feedback > Send a suggestion, or by voting for The maximum row of excel is 1048576. Yes. Can you increase the number of rows?
- Thank you for the link I have made a comment