Excel 2010 Bible

Chapter 2: Entering and Editing Worksheet Data 39 FIGURE 2.5 This series was created by using AutoFill. Using AutoComplete to au ...

Part I: Getting Started with Excel 40 Forcing text to appear on a new line within a cell ....................................... ...

Chapter 2: Entering and Editing Worksheet Data 41 FIGURE 2.6 AutoCorrect allows you to create shorthand abbreviations for text y ...

Part I: Getting Started with Excel 42 After performing these steps, a new icon appears on your Quick Access toolbar. To use a da ...

Chapter 2: Entering and Editing Worksheet Data 43 Tip The formatting that you apply works with the selected cell or cells. There ...

Part I: Getting Started with Excel 44 Tip A handy default feature in Excel makes entering percentage values into cells easier. I ...

Chapter 2: Entering and Editing Worksheet Data 45 Using shortcut keys to format numbers ........................................ ...

Part I: Getting Started with Excel 46 FIGURE 2.10 When you need more control over number formats, use the Number tab of the Form ...

Chapter 2: Entering and Editing Worksheet Data 47 l (^) Number: Enables you to specify the number of decimal places, whether to ...

Part I: Getting Started with Excel 48 Applying a number format to a cell doesn’t change the value — only how the value appears i ...

49 CHAPTER Essential Worksheet Operations IN THIS CHAPTER Understanding Excel worksheet essentials Controlling your views Manipu ...

Part I: Getting Started with Excel 50 Figure 3.1 shows Excel with four workbooks open, each in a separate window. One of the win ...

Chapter 3: Essential Worksheet Operations 51 l (^) Maximized: Fills the entire Excel workspace. A maximized window doesn’t have ...

Part I: Getting Started with Excel 52 Switching among windows .................................................................. ...

Chapter 3: Essential Worksheet Operations 53 l (^) Choose File ➪ Close. l Click the Close button (the X icon) on the workbook wi ...

Part I: Getting Started with Excel 54 Adding a new worksheet to your workbook .................................................. ...

Chapter 3: Essential Worksheet Operations 55 To change a sheet’s name, double-click the sheet tab. Excel highlights the name on ...

Part I: Getting Started with Excel 56 To change the color of a sheet tab, right-click the tab and choose Tab Color from the shor ...

Chapter 3: Essential Worksheet Operations 57 If you move or copy a worksheet to a workbook that already has a sheet with the sam ...

Part I: Getting Started with Excel 58 To unhide a hidden worksheet, right-click any sheet tab and choose Unhide Sheet. Excel ope ...