Excel 2016 All-in-One For Dummies. Harvey Greg

Чтение книги онлайн.

СКАЧАТЬ target="_blank" rel="nofollow" href="#i000047220000.jpg" alt="touchscreen"/> On a touchscreen, you scroll the worksheet by swiping the screen with your finger. (Don’t use your stylus because pressing it in the worksheet area only results in selecting the cell you touch). You swipe upward to scroll worksheet rows down and swipe down to scroll the rows up. Likewise, you swipe left to scroll columns right and swipe right to scroll columns left.

       The only disadvantage to using the scroll bars to move around is that the scroll bars bring only new sections of the worksheet into view – they don’t actually change the position of the cell cursor. If you want to start making entries in the cells in a new area of the worksheet, you still have to remember to select the cell (by clicking it) or the group of cells (by dragging through them) where you want the data to appear before you begin entering the data.

      One good reason for adding extra sheets to a workbook

      You may wonder why on earth anyone would ever need more than three worksheets, given just how many cells each individual sheet contains. The simple truth is that it’s all about how you choose to structure a particular spreadsheet rather than running out of places to put the data. For example, say you need to create a workbook that contains budgets for all the various departments in your corporation; you may decide to devote an individual worksheet to each department (with the actual budget spreadsheet tables laid out in the same manner on each sheet) rather than placing all the tables in different sections of the same sheet. Using this kind of one-sheet-per-budget layout makes it much easier for you to find each budget, print each one as a separate page of a report, and, if ever necessary, consolidate their data in a separate summary worksheet.

       Surfing the sheets in a workbook

      Each new workbook you open in Excel 2016 contains a single blank worksheet, aptly named Sheet1, with 16,384 columns and 1,048,576 rows (giving you a truly staggering total of 51,539,607,552 blank cells!). Should you still need more worksheets in your workbook, you can add them simply by clicking the New Sheet button (the circle with the plus sign in it) that appears to the immediate right of Sheet1 tab.

      On the left side of the bottom of the Worksheet area, the Sheet tab scroll buttons appear, followed by the actual tabs for the worksheets in your workbook and the New Sheet button. To activate a worksheet for editing, you select it by clicking its sheet tab. Excel lets you know what sheet is active by displaying the sheet name on its tab in green, boldface type as well as underlining the tab and making the tab appear to be connected to the current worksheet above.

       Don’t forget the Ctrl+Page Down and Ctrl+Page Up shortcut keys for selecting the next and previous sheets, respectively, in your workbook. You can also click the Next Sheet and Previous Sheet button marked by the ellipsis (…). The Next Sheet button is the one with the ellipsis on the right side of the sheet tabs immediately left of the New Sheet button. The Previous Sheet button is the one with ellipsis on the left side of the sheet tabs to the immediate left of the first visible sheet tab.

      If your workbook contains too many sheets for all their tabs to be displayed at the bottom of the Worksheet area, use the Sheet tab scroll buttons to bring new tabs into view (so that you can then click them to activate them). You click the Next Scroll button (the one with the triangle pointing right) to scroll the next hidden sheet tab into view on the right and the Previous Scroll button (the one with the triangle pointing left) to scroll the next hidden sheet into view on the left. You Ctrl+click the Next Scroll button to scroll the last sheet into view and Ctrl+click the Previous Scroll button to scroll the first sheet into view.

       Right-click either Sheet tab scroll button to display the Activate dialog box listing the names of all the worksheets in the workbook in their order from first to last. Then, to scroll to and select a worksheet, double-click its name or click the name followed by the OK button.

Taking a tour of the status bar

The status bar is the last component at the very bottom of the Excel program window. (See Figure 1-6.) The status bar contains the following areas:

       Figure 1-6: The Excel 2016 status bar.

      ✔ Mode: This button indicates the current state of the Excel program (READY, ENTER, EDIT, and so on).

      ✔ AutoCalculate: This indicator displays the AVERAGE, COUNT, and SUM of all the numerical entries in the current cell selection.

      ✔ Layout: This selector enables you to select between three layouts for the Worksheet area: Normal, the default view that shows only the worksheet cells with the column and row headings; Page Layout view, which adds rulers and page margins and shows page breaks for the worksheet; and Page Break Preview, which enables you to adjust the paging of a report.

      ✔ Zoom: The Zoom slider enables you to zoom in and out on the cells in the Worksheet area by dragging the slider to the right or left, respectively.

       When you begin recording your first macro in Excel 2016 (see Book VIII, Chapter 1 for details), a Stop Recording button (with a square icon) appears on the status bar to the immediate right of the Mode indicator. When you finish recording this macro, the Stop Recording button on the status bar immediately changes into a Record Macro button (using an icon with a dot on a tiny worksheet) that you can thereafter use to record any or all your future macros.

      Getting Help

      In Excel 2016, help is always available to you in two forms:

      ✔ Tell Me help feature that not only shows you the command sequence for the help topic you enter but at times actually initiates and completes the command sequence for you

      ✔ Online Help that contains various help topics that explain Excel’s many features

Show-and-tell help with the Tell Me feature

      Excel 2016’s new Tell Me help feature must be from Missouri because it doesn’t just tell you what to do; it actually shows you by performing the task for you. This handy little feature is available from the Tell Me What You Want to Do text box located to the immediate right of the last command tab above the Excel ribbon. As you enter a help topic into this text box, Excel displays a list of related Excel commands in a drop-down list.

      When you then select one of the items displayed on this list, Excel either selects the associated Ribbon command (no matter which Ribbon tab is currently selected) and waits for you to make a selection from the command’s submenu or, in some case, just goes ahead and completes the associated command sequence for you.

      For example, if you type print into the Tell Me What You Want to Do text box, Excel displays a list with the following items:

      ✔ Quick Print

      ✔ Preview and Print

      ✔ Print Preview and Print

      ✔ Print Guidelines

      ✔ Print Area

      ✔ See Help for “Print”

      If you select Quick Print at the top of the list, Excel immediately sends the СКАЧАТЬ