Q:

What is the maximum number of worksheets available in an Excel workbook?

A:

Quick Answer

Excel 2010 does not have a specific maximum number of worksheets available in a workbook. The maximum number is limited by the amount of available memory in a system. The default setting is three sheets.

Continue Reading

Full Answer

Excel does have limitations in other areas. For instance, the maximum worksheet size is 65,536 rows by 256 columns. Columns are no wider than 255 characters. The text in an individual cell must not exceed 32,767 characters. Fifty-six font colors are accessible in a workbook, and 4,000 different cell styles are available. A worksheet is allowed no more than 66,530 hyperlinks.

The “undo” function cancels out up to 16 levels of work.

Learn more about Software

Related Questions

  • Q:

    Where can you learn to use Excel?

    A:

    Microsoft offers a free training center for Excel as of 2015. The database includes courses for Excel on Windows, Mac OS, Android, iOS and Windows Phone. Alternatively, users can access a help database within Excel by pressing F1 or by clicking the blue help button on the top-right.

    Full Answer >
    Filed Under:
  • Q:

    How do you subtract in Excel?

    A:

    To subtract in Excel, enter the numbers in a cell using the formula =x-y, complete the same formula using the column and row headings of two different cells, or use the SUM function with negative numbers. Excel does not have a specific SUBTRACT function.

    Full Answer >
    Filed Under:
  • Q:

    What is "mean" in Excel?

    A:

    In Excel, the mean function is used to calculate the average of a set of numbers. The numbers used can come from any cell in an Excel spreadsheet by listing the cells involved into the average function box.

    Full Answer >
    Filed Under:
  • Q:

    What is a workbook?

    A:

    A workbook is an electronic spreadsheet file that contains one or more worksheets. Workbooks are the primary file format used for saving data in spreadsheet software.

    Full Answer >
    Filed Under:

Explore