What is the maximum number of worksheets you can have in a single Excel workbook?

a) 50

b) 255

c) 1000

d) Unlimited

Show Answer

b) 255

In Microsoft Excel, the maximum number of worksheets you can have in a single workbook is 1,048,576. This is the case for Excel 2007 and later versions (Excel 2010, 2013, 2016, 2019, and Microsoft 365). Each worksheet is identified by a tab at the bottom of the Excel window, and you can rename and organize them to suit your needs within this limit.