Question

In excel,howvmany maximum worksheet a workbook contain is

Answer 1

Worksheet and workbook specifications and limits

Feature

Maximum limit

Open workbooks

Limited by available memory and system resources

Total number of rows and columns on a worksheet

1,048,576 rows by 16,384 columns

Column width

255 characters

Row height

409 points

Page breaks

1,026 horizontal and vertical

Total number of characters that a cell can contain

32,767 characters

Characters in a header or footer

255

Maximum number of line feeds per cell

253

Sheets in a workbook

Limited by available memory (default is 1 sheet)

Colors in a workbook

16 million colors (32 bit with full access to 24 bit color spectrum)

Named views in a workbook

Limited by available memory

Unique cell formats/cell styles

64,000

Fill styles

256

Line weight and styles

256

Unique font types

1,024 global fonts available for use; 512 per workbook

Number formats in a workbook

Between 200 and 250, depending on the language version of Excel that you have installed

Names in a workbook

Limited by available memory

Windows in a workbook

Limited by available memory

Hyperlinks in a worksheet

66,530 hyperlinks

Panes in a window

4

Linked sheets

Limited by available memory

Scenarios

Limited by available memory; a summary report shows only the first 251 scenarios

Changing cells in a scenario

32

Adjustable cells in Solver

200

Custom functions

Limited by available memory

Zoom range

10 percent to 400 percent

Reports

Limited by available memory

Sort references

64 in a single sort; unlimited when using sequential sorts

Undo levels

100

Fields in a data form

32