Fast answers to frequently asked questions
Excel 2007 essentials at your fingertips!
If you like your answers quick and your information up-to-date, look no further. With this concise, superbly organized reference, you'll quickly find just what you need to know about navigating the new interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much more.
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. In older versions of Excel (well, except for really old versions), each worksheet used a grid with 65,536 rows and 256 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. Prior to Excel 2007, row numbers ranged from 1 to 65,536 and column labels ranged from A (column 1) to IV (column 256).