Excel 2010 Bible

Chapter 4: Working with Cells and Ranges 79 Note Copying a cell normally copies the cell’s contents, any formatting that is appl ...

Part I: Getting Started with Excel 80 New Feature The Home ➪ Clipboard ➪ Paste control contains a drop-down arrow that, when cli ...

Chapter 4: Working with Cells and Ranges 81 FIGURE 4.8 The paste icons on the shortcut menu provide more control over how the pa ...

Part I: Getting Started with Excel 82 Tip If the mouse pointer doesn’t turn into an arrow when you point to the border of a cell ...

Chapter 4: Working with Cells and Ranges 83 Excel provides additional options for copying to adjacent cells. To use these comman ...

Part I: Getting Started with Excel 84 Using the Office Clipboard to paste ...................................................... ...

Chapter 4: Working with Cells and Ranges 85 You can clear the contents of the Office Clipboard by clicking the Clear All button. ...

Part I: Getting Started with Excel 86 l (^) Transpose (T): Changes the orientation of the copied range. Rows become columns, and ...

Chapter 4: Working with Cells and Ranges 87 Note After you paste, you’re offered another chance to change your mind. A Smart Tag ...

Part I: Getting Started with Excel 88 l (^) Formats: Copies only the formatting. l Comments: Copies only the cell comments from ...

Chapter 4: Working with Cells and Ranges 89 Skipping blanks when pasting ....................................................... ...

Part I: Getting Started with Excel 90 l (^) A meaningful range name (such as Total_Income) is much easier to remember than a cel ...

Chapter 4: Working with Cells and Ranges 91 FIGURE 4.13 Create names for cells or ranges by using the New Name dialog box. Type ...

Part I: Getting Started with Excel 92 create names based on the top row. If Excel didn’t guess correctly, you can change the che ...

Chapter 4: Working with Cells and Ranges 93 FIGURE 4.15 Use the Name Manager to work with range names. The Name Manager appears ...

Part I: Getting Started with Excel 94 Tip The Name Manager is useful, but it has a shortcoming: It doesn’t let you display the l ...

Chapter 4: Working with Cells and Ranges 95 You can force a comment to be displayed even when its cell is not activated. Right-c ...

Part I: Getting Started with Excel 96 Changing a comment’s shape ............................................................... ...

Chapter 4: Working with Cells and Ranges 97 Click the dialog box launcher in the Page Layout ➪ Page Setup group. This is the sm ...

Part I: Getting Started with Excel 98 Editing comments ......................................................................... ...