Excel 2010 Bible

Chapter 3: Essential Worksheet Operations 59 Zooming in or out for a better view ............................................... ...

Part I: Getting Started with Excel 60 Tip Zooming affects only the active worksheet, so you can use different zoom factors for d ...

Chapter 3: Essential Worksheet Operations 61 FIGURE 3.6 Use multiple windows to view different sections of a workbook at the sam ...

Part I: Getting Started with Excel 62 Splitting the worksheet window into panes ................................................ ...

Chapter 3: Essential Worksheet Operations 63 To freeze panes, start by moving the cell pointer to the cell below the row that yo ...

Part I: Getting Started with Excel 64 FIGURE 3.9 When using a table, scrolling down displays the table headings where the column ...

Chapter 3: Essential Worksheet Operations 65 Tip Double-click a cell in the Watch Window to immediately select that cell. n Work ...

Part I: Getting Started with Excel 66 FIGURE 3.11 You can’t add a new row or column if it causes nonblank cells to move off the ...

Chapter 3: Essential Worksheet Operations 67 To hide rows or columns in your worksheet, select the row or rows that you want to ...

Part I: Getting Started with Excel 68 l (^) Drag the right-column border with the mouse until the column is the desired width. l ...

69 CHAPTER Working with Cells and Ranges IN THIS CHAPTER Understanding Excel cells and ranges Selecting cells and ranges Copying ...

Part I: Getting Started with Excel 70 Selecting ranges ......................................................................... ...

Chapter 4: Working with Cells and Ranges 71 Selecting complete rows and columns ................................................ ...

Part I: Getting Started with Excel 72 FIGURE 4.2 Excel enables you to select noncontiguous ranges. Note Noncontiguous ranges dif ...

Chapter 4: Working with Cells and Ranges 73 FIGURE 4.3 The worksheets in this workbook are laid out identically. Assume that you ...

Part I: Getting Started with Excel 74 Choose Home ➪ Font ➪ Bold and then choose Home ➪ Font ➪ Fill Color to apply a colored bac ...

Chapter 4: Working with Cells and Ranges 75 FIGURE 4.5 Use the Go to Special dialog box to select specific types of cells. Table ...

Part I: Getting Started with Excel 76 TABLE 4.1 (continued) Option What It Does Precedents Selects cells that are referred to in ...

Chapter 4: Working with Cells and Ranges 77 FIGURE 4.6 The Find and Replace dialog box, with its options displayed. FIGURE 4.7 T ...

Part I: Getting Started with Excel 78 Wildcard characters also work with values. For example, searching for 3* locates all cells ...