Excel documents are known as workbooks. A single workbook can store as many sheets as will fit into memory, and these sheets are stacked like the pages in a notebook. Sheets can be either worksheets (a normal spreadsheet-type sheet with rows and columns) or chart sheets (a special sheet that holds a single chart).
Most of the time, you perform tasks in worksheets. Each worksheet uses a grid with 1,048,576 rows and 16,384 columns. Excel numbers rows starting with 1 and assigns letters to columns starting with A. After Excel exhausts the letters of the alphabet, column lettering continues with AA, AB, and so on. So column 1 is A, column 26 is Z, column 27 is AA, column 52 is AZ, column 53 is BA, and so on. Rows are numbered from 1 to 1,048,576, and columns are labeled from A to XFD.
The intersection of a row and a column is called a cell. A quick calculation using Excel tells us that this works out to 17,179,869,184 cells — more than enough for just about any use. Cells have addresses, which are based on their row and column. The upper-left cell in a worksheet is called A1, and the cell down at the bottom right is called XFD1048576. Cell K9 (also known as the dog cell) is the intersection of the eleventh column and the ninth row.
You might be wondering about the amount of system memory (known as random access memory, or RAM) you need to accommodate all those rows and columns. The memory you need depends on the amount of data you store in the workbook and the number of open workbooks. In Excel 2010, the memory available is limited by the maximum amount of memory that your version of Windows (XP, Vista, or Windows 7) can use.
Download
0 comments:
Post a Comment