Excel 2019 Bible

Part I: Getting Started with Excel FIGURE 2.6 AutoCorrect allows you to create shorthand abbreviations for text you enter often. ...

Chapter 2: Entering and Editing Worksheet Data 2 FIGURE 2.7 Excel’s built-in data form can simplify many data-entry tasks. Unfor ...

Part I: Getting Started with Excel To use a data entry form, follow these steps: Arrange your data so that Excel can recognize ...

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

Part I: Getting Started with Excel Using automatic number formatting Excel is able to perform some formatting for you automatica ...

Chapter 2: Entering and Editing Worksheet Data 2 FIGURE 2.9 You can find number formatting commands in the Number group of the H ...

Part I: Getting Started with Excel Formatting numbers by using the Format Cells dialog box In most cases, the number formats tha ...

Chapter 2: Entering and Editing Worksheet Data 2 The Number tab of the Format Cells dialog box displays 12 categories of number ...

Part I: Getting Started with Excel Number Enables you to specify the number of decimal places, whether to use a comma to separat ...

51 C H A P T E R 3 Performing Basic Worksheet Operations IN THIS CHAPTER Understanding Excel worksheet basics Controlling your v ...

Part I: Getting Started with Excel In previous versions of Excel, every workbook opened in a single Excel window. Beginning with ...

Chapter 3: Performing Basic Worksheet Operations 3 FIGURE 3.1 Use the Arrange Windows dialog box to arrange all open nonminimize ...

Part I: Getting Started with Excel You also can display a single workbook in more than one window. For example, if you have a wo ...

Chapter 3: Performing Basic Worksheet Operations 3 FIGURE 3.2 Use the tab scrolling controls to activate a different worksheet o ...

Part I: Getting Started with Excel FIGURE 3.3 Excel’s warning that you might be losing some data You can delete multiple sheets ...

Chapter 3: Performing Basic Worksheet Operations 3 ? Question mark * Asterisk Keep in mind that a longer worksheet name results ...

Part I: Getting Started with Excel FIGURE 3.4 Use the Move or Copy dialog box to move or copy worksheets in the same or another ...

Chapter 3: Performing Basic Worksheet Operations 3 which lists all hidden sheets. Choose the sheet that you want to redisplay, a ...

Part I: Getting Started with Excel ■ (^) Choose View ➪ Zoom ➪ Zoom, which displays a dialog box with some zoom options. Also in ...

Chapter 3: Performing Basic Worksheet Operations 3 You can close these additional windows when you no longer need them. For exam ...