TIL: Excel spreadsheet can handle 1,048,576 rows and 16,384 columns at a time.

Read more: https://earnandexcel.com/blog/how-can-you-analyze-1m-rows-in-excel/

What do you think?

8 Comments

Leave a Reply
  1. Not really. Having used it with hundreds of thousands of rows: it would slow down to be unusable and then crash long before you could use all of them simultaneously.

    But you can definitely address them and use them, as long as you didn’t have all that much data (or maybe it was a completely static sheet).

Leave a Reply