each worksheet in an excel workbook can hold a maximum of how many rows of data?
Each worksheet in a modern Excel workbook can hold a maximum of 1,048,576 rows of data.
Each worksheet in a modern Excel workbook can hold a maximum of 1,048,576 rows of data.