excel How big is a worksheet?

It’s interesting to stop and think about the actual size of a worksheet. Do the arithmetic (16,384 ×
1,048,576), and you’ll see that a worksheet has 17,179,869,184 cells. Remember that this is in just one
worksheet. A single workbook can hold more than one worksheet.
If you’re using a 1600 x 1200 video mode with the default row heights and column widths, you can see
24 columns and 49 rows (or 1,176 cells) at a time — which is about .0000068 percent of the entire
worksheet. In other words, more than 14.6 million screens of information reside within a single worksheet.
If you entered a single digit into each cell at the relatively rapid clip of one cell per second, it would
take you over 500 years, nonstop, to fill up a worksheet. To print the results of your efforts would
require more than 36 million sheets of paper — a stack about 12,000 feet high. (That’s ten Empire
State Buildings stacked on top of each other.)
As you might suspect, filling an entire workbook with values is impossible. It’s not even close to being
possible. Even if you use the 64-bit version of Excel, you’d soon run out of memory, and Excel would
probably crash.
The real value of using multiple worksheets in a workbook isn’t access to more cells. Rather, multiple worksheets enable you to organize your work better. Back in the old days, when a file comprised a single worksheet, developers wasted a lot of time trying to organize the worksheet to
hold their information efficiently. Now you can store information on any number of worksheets
and still access it instantly by clicking a sheet tab.