Microsoft Excel - how many pages are there in one MS Excel worksheet?

Asked By konvicted on 05-Jan-11 12:28 AM
end of post
Jackpot . replied to konvicted on 05-Jan-11 12:48 AM
What do you mean by page?

If you mean print page that depends on the used range (or the data range), paper size, row height and column width
Reena Jain replied to konvicted on 05-Jan-11 01:07 AM
hi,

According to Microsoft Excel, the number of worksheets in a workbook is "limited only by available memory." Current versions of Excel cannot use more than 1 GB of memory even if more memory is available on the system. (Excel 2007 will use as much memory as the system will give it. You set this here: Tools > Options: General, "Sheets in new workbook")


hope this will help you
Anoop S replied to konvicted on 05-Jan-11 01:20 AM
It is basically limited by the size of your computer memory. As a general rule it is not a good idea to have too many and it is a bad way to use a spreadsheet. It can be easier to use different workbooks for different things rather than having too many sheets in one workbook. Another advantage is that if the one file with everything in it gets damaged, then you have lost everything. If you work is in several files and you lose one, you have not lost everything.

The maximum number of sheets in an Excel 2007 workbook is governed by available memory. To see available memory in Excel, open Help and type in "specifications."

The maximum number of Worksheets can be inserted in excel 2003 or earlier is 255 sheets.

According to Microsoft: The maximum number of worksheets is not defined in Excel, but external factors, such as memory and disk space, might causes limitations to be applied.

In Excel 2007 you can add as many worksheets as you like, limited by the memory available to your computer, since all worksheets must reside in memory at the same time. When you first start Excel, the default is three pages available, but if you click on one of the page tabs, you can add more sheets.

With Excel 2007, there are three default worksheets that open with a new worksheet. The total number of worksheets possible in a single Excel 2007 workbook are limited only by the amount of memory in your computer, since all worksheets must reside in memory at the same time.

Read more: http://wiki.answers.com/Q/How_many_worksheets_can_an_Excel_workbook_have#ixzz1A8gr7wCU
Jackpot . replied to Anoop S on 05-Jan-11 07:01 AM
Hi Anoop

The OP has specified one worksheet not workbook.