Forum Discussion
Re configuring an excel sheet for less columns and more rows
Hello, I don't post in here often, but there is one question I've always wondered about with Excel. I use Excel to process RAW DNA data from direct to customer testing companies like Ancestry, ...
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