Tuesday, February 8, 2011

How big is a Excel 2010 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).

No comments:

Post a Comment