Forum Discussion

Tim Orszula's avatar
Tim Orszula
Copper Contributor
Aug 21, 2018

How to increase number of rows in excel sheet?

I have a need to increase the number of rows past the 1 million limit in Excel.  What are my options?

excel

2 Replies

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Aug 22, 2018
    just thinking out loud:
    if your row will be 100 columns -
    you will have more than 170 million "rows" per worksheet at your disposal....
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 21, 2018

    Hi Tim,

     

    No way, you can't expand Excel sheet limits. On the other hand you may load your data into data model and process them using Power View returning compact result into Excel sheet. Here are formal limits as well, but practically it's limited only by your memory size.

Resources