how many tabs on a excel spreadsheet can you have?

G

Guest

I have a single working Excel Document, with additional tabs for spreadsheets
on it, what is the maximum number that I can have on one Excel document?
 
G

Gord Dibben

The tabs are named worksheet tabs, not spreadsheet tabs.

Help on "specifications" reads default number of sheets in a new workbook is
255.

You may add more after opening depending upon your resources available.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Transfer of customized excel tabs with UI Editor but VBA code not working 0
PivotTable Tools -> Options/Design tabs 1
Maximum number of data validation cells? 3
Section Breaks in Excel 5
DROP DOWN LIST 3
Recover lost excel tabs/spreadsheets from workbook 2
SUMIF FUNCTION works in all cells but those related to one account 4
Import Many Tabs from Many Spreadsheets 1

Top