Excel 2010 For Dummies Quick Reference
Format: PDF / Kindle (mobi) / ePub
Find the answers to your most important Excel questions with this reference
John Walkenbach’s name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach—along with Excel expert Colin Banfield—answers your most common and important Excel questions in this easy-to-understand reference.
You'll learn how to open, save, protect, and recover workbook files; add, copy, and delete worksheets; enter and edit data and text; create formulas and functions; audit, format, and print; and more. Highly organized and free of unnecessary jargon, this essential reference allows you to find the answers you’re looking for quickly and easily.
- Excel gurus Walkenbach and Banfield offer quick and easy answers to common Excel questions
- Offers information in a highly organized, easy-to-understand format so you can find exactly what you need
- Includes information on opening, saving, protecting and recovering workbook files; adding, copying, and deleting worksheets; entering and editing data and text; creating formulas and functions; auditing; formatting; printing; and more
- Covers navigating the user 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 2010 For Dummies Quick Reference enables you to spend more time working on your projects rather than trying to figure how to make Excel work for you!
row down (active cell doesn’t change) Left arrow* Scrolls the screen one column left (active cell doesn’t change) Right arrow* Scrolls the screen one column right (active cell doesn’t change) * With Scroll Lock on Introducing the Ribbon Excel comes with a user interface called the Ribbon, which consists of a series of horizontal tabs, each containing a variety of commands grouped according to function (see Figure 1-3). Most features in Excel 2010 are available through the commands on the
range and choose Copy from the contextual menu.) 2. 3. Select only the upper-left cell of the range that you want to use to hold the copy. Complete Steps 4 and 5 in the section “Copying a cell to another cell or a range,” immediately preceding in this part. 4. If you intend to use the default paste option and you decide that the location you’re copying to isn’t too far away, you can follow these steps: 1. Select the cell or range to copy. 2. Press and hold down Ctrl. 3. Move the mouse
table summarizes all possible types of cell references and shows how a reference changes after it is copied one cell down or one cell across. In all cases, the absolute portion of the reference is unchanged. Type Example Down Across Relative reference =A1 =A2 =B1 Absolute reference =$A$1 =$A$1 =$A$1 Mixed reference (column part is absolute) =$A1 =$A2 =$A1 Mixed reference (row part is absolute) =A$1 =A$1 =B$1 To change the type of cell reference in a formula, follow these
automatically use the name in place of existing references in your formulas. For example, if you have a formula such as =A1*20 and then give a name to cell A1, the formula continues to display A1 (not the new name). Replacing cell or range references with their corresponding names, however, is fairly easy. 08_527559-ch06.indd 92 4/1/10 10:39 PM Advantages to Naming Cells and Ranges — Creating Names 93 To apply names to cell references in existing formulas, follow these steps: 1. Select the
problems, Excel continues to display the circular reference message on the status bar. Excel doesn’t tell you about a circular reference if the Iteration setting is on. You can check this setting by clicking the File tab, clicking the Options button, and then clicking the Formulas option section in the left pane. The Enable Iterative Calculation option is in the Calculation Options area on the right side of the dialog box. If iteration is on (that is, the Enable Iterative Calculation option is