Excel 2019 Bible

Part I: Getting Started with Excel active workbook. Activate the first window; then choose View ➪ Window ➪ View Side by Side. If ...

Chapter 3: Performing Basic Worksheet Operations 3 Figure 3.7 shows a worksheet with frozen panes. In this case, rows 4:7 and co ...

Part I: Getting Started with Excel FIGURE 3.7 Freeze certain columns and rows to make them remain visible while you scroll the w ...

Chapter 3: Performing Basic Worksheet Operations 3 Monitoring cells with a Watch Window In some situations, you may want to moni ...

Part I: Getting Started with Excel Inserting rows and columns Although the number of rows and columns in a worksheet is fixed, y ...

Chapter 3: Performing Basic Worksheet Operations 3 FIGURE 3.11 You can insert partial rows or columns by using the Insert dialog ...

Part I: Getting Started with Excel Changing column widths Column width is measured in terms of the number of characters of a mon ...

Chapter 3: Performing Basic Worksheet Operations 3 You can set the row height manually, however, by using any of the following t ...

71 C H A P T E R 4 Working with Excel Ranges and Tables IN THIS CHAPTER Understanding Excel cells and ranges Selecting cells and ...

Part I: Getting Started with Excel Selecting ranges To perform an operation on a range of cells in a worksheet, you must first s ...

Chapter 4: Working with Excel Ranges and Tables 4 Selecting complete rows and columns Often, you’ll need to select an entire row ...

Part I: Getting Started with Excel FIGURE 4.2 Excel enables you to select noncontiguous ranges. Selecting multisheet ranges In a ...

Chapter 4: Working with Excel Ranges and Tables 4 FIGURE 4.3 The worksheets in this workbook are laid out identically. This work ...

Part I: Getting Started with Excel FIGURE 4.4 In Group mode, you can work with a three-dimensional range of cells that extend ac ...

Chapter 4: Working with Excel Ranges and Tables 4 click the sheet tab of each additional worksheet that you want to select. If a ...

Part I: Getting Started with Excel After you make your choice in the dialog box, Excel selects the qualifying subset of cells in ...

Chapter 4: Working with Excel Ranges and Tables 4 Option What it does Last Cell Selects the bottom-right cell in the worksheet t ...

Part I: Getting Started with Excel Enter the text you’re looking for; then click Find All. The dialog box expands to display all ...

Chapter 4: Working with Excel Ranges and Tables 4 To search for a question mark or an asterisk, precede the character with a til ...

Part I: Getting Started with Excel Copying or moving consists of two steps (although shortcut methods are available): Select th ...