Thursday, July 7, 2011

Size of Excel Worksheet :-

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 1024 × 768 video mode with the default row heights and column widths, you can  see 15 columns and 25 rows (or 375 cells) at a time - which is about .000002 percent of the entire worksheet. In other words, more than 45 million screens of information reside within a single worksheet.If you were to enter a single digit into each cell at the relatively rapid clip of one cell per second, it would take you about 545 years, nonstop, to fill up a worksheet. To print the results of your efforts would require more than 40 million sheets of paper - a stack more than a mile high. As you might suspect, filling an entire workbook with values is not possible. It's not even close to
being possible. You would soon run out of memory, and Excel would probably crash.You have complete control over the column widths and row heights - in fact, you can even hide rows and
columns (as well as entire worksheets). You can specify any font size, and you have complete control over
colors. Text in a cell can be displayed vertically (or at an angle) and can even be wrapped around to occupy
multiple lines. NEW In the past, Excel was limited to a palette of 56 colors. With Excel 2007, the number of
colors is  virtually unlimited. In addition, Excel 2007 supports document themes. A single click lets you
apply a new theme to a workbook, which can give it an entirely different look.

No comments: