Excel 2019 Bible

Part I: Getting Started with Excel FIGURE 5.21 Excel displays samples of predefined cell styles. After you apply a style to a ce ...

Chapter 5: Formatting Worksheets 55 Click the Format button. Excel displays the Format Cells dialog box. Click the Font tab, an ...

Part I: Getting Started with Excel Enter a new style name in the Style Name field. The check boxes display the current formats ...

Chapter 5: Formatting Worksheets 55 Understanding Document Themes In an attempt to help users create more professional-looking d ...

Part I: Getting Started with Excel Figure 5.24 shows the same worksheet after applying a different document theme. The dif- fere ...

Chapter 5: Formatting Worksheets 55 A theme applies to the entire workbook. You can’t use different themes on different workshee ...

Part I: Getting Started with Excel Each theme uses two fonts (one for headers and one for the body), and in some cases these two ...

Chapter 5: Formatting Worksheets 55 FIGURE 5.27 If you’re feeling creative, you can specify a set of custom colors for a theme. ...

153 C H A P T E R 6 Understanding Excel Files and Templates IN THIS CHAPTER Creating a new workbook Opening an existing workbook ...

Part I: Getting Started with Excel FIGURE 6.1 Choosing Blank Workbook from Excel’s Start screen While you’re working in Excel, y ...

Chapter 6: Understanding Excel Files and Templates 6 ■ (^) Locate the Excel workbook file via a File Explorer file list. Just do ...

Part I: Getting Started with Excel About Protected View Excel 2010 introduced a security feature known as Protected View. Althou ...

Chapter 6: Understanding Excel Files and Templates 6 You can also type a filter directly in the File Name box. For example, typi ...

Part I: Getting Started with Excel Excel provides four ways to save your workbook: ■ Click the Save icon on the Quick Access too ...

Chapter 6: Understanding Excel Files and Templates 6 If a file with the same name already exists in the location that you specif ...

Part I: Getting Started with Excel FIGURE 6.2 You can recover to older versions of your workbook. Recovering unsaved work When y ...

Chapter 6: Understanding Excel Files and Templates 6 File-Naming Rules Excel workbook files are subject to the same rules that a ...

Part I: Getting Started with Excel Enter the password, click OK, and then enter it again. Click OK and save the workbook. When ...

Chapter 6: Understanding Excel Files and Templates 6 Protect Current Sheet This command lets you protect various elements of a w ...

Part I: Getting Started with Excel Compatibility Mode section If the active workbook is an old workbook opened in compatibility ...