If, however, you select Preview and Print next on the list, a submenu with Print Preview and Print, Quick Print, and Print Preview Full Screen appears. If you select the Print Preview and Print item, Excel displays a preview of the printout on the Print Screen in the Backstage view that you can print. If you select the Quick Print item, the program sends the worksheet directly to the printer. But if you select the Print Preview Full Screen item, Excel replaces the Worksheet view with a full screen print preview page from which you can print the worksheet. (See Chapter 5 for complete details on previewing and printing your worksheets.)
On the other hand, if you type underline in the Tell Me What You Want to Do text box, Excel displays two items: Underline and See Help for “Underline.” If you then select the Underline item, Excel goes ahead and assigns the underlining font attribute to whatever is in the cell that’s current in the worksheet.
Excel 2016 offers extensive online help that you can make use of anytime while using the program. To display the Excel Help window, you press function key F1. When you do, an Excel 2016 Help window similar to the one shown in Figure 1-7 appears.
Figure 1-7: The Excel 2016 Help window with help topics for on printing worksheets.
This window contains a search text box with a Search button to the right (with the spyglass icon) below a group of command buttons (Back, Next, Home, Print, and Increase Font). To display a list of related help topics in the Help window, type a keyword or name of a category (such as printing, formulas, and so on) and then click the Search button or press Enter. The Excel 2016 Help window then displays a list of help topics for that category. To display detailed information about a particular help topic in this list, click its link.
To print the contents of the help topic that you select, click the Print button (the one with the Printer icon) at the top of the Excel Help window. To return to the opening Excel Help screen, click the Home button. To return to the previous Help screen after reviewing several links in a row, click the Back button (the one with arrow pointing left).
Launching and Quitting Excel
Excel 2016 runs under both the older Windows 7 and 8 as well as the new Windows 10 operating systems. Although the basic procedure for launching Excel 2016 in all three versions of the Windows operating system is pretty much the same, due to the variations to the Windows desktop, you should consult the Excel startup sequence for your particular version of Windows, which I outline in the following sections.
Windows 10 brings back the good old Start menu that many of you remember from much earlier Windows versions. The Windows 10 Start menu combines the straight up menu from earlier days with the tile icons so prominent in Windows 8. To open this menu to launch Excel 2016, click the Windows icon on the taskbar or press the Windows key on your keyboard.
Then, click the All Apps button under the list of the Most Used applications in the menu and scroll down to Microsoft Office 2016 under the E’s in the list. Select the Expand button (with the caret pointing downward) to display your Office applications where you click Excel 2016, as shown in Figure 1-8.
Figure 1-8: Launching Excel 2016 from the Windows 10 Start screen.
Instead of opening the Windows 10 Start menu and locating the Excel 2016 item there, you can launch the program by selecting this item from the Ask Me Anything text box. Simply type excel into this text box that appears to the immediate right of the Windows button on the taskbar and click Excel 2016 at the top of its result list.
If you want Cortana, the voice-activated online Windows 10 assistant, to launch Excel 2016 for you, click the microphone icon in the Ask Me Anything text box and then when she displays the listening prompt, say “Cortana, start Microsoft Excel 2016.”
When starting Excel 2016 from the Windows 8 Start screen, you simply select the Excel 2016 program tile either by clicking it if you have a mouse available or tapping it with your finger or stylus if you’re running Windows 8 on a touchscreen device.
If you can’t locate the Excel 2016 tile among those displayed on the Start screen, use the Search feature to find the application and pin it to the Windows 8 Start screen:
1. From the Start screen, begin typing exc on your physical or Touch keyboard.
Windows 8 displays Excel 2016 in the list of programs under Apps on the left side of the screen.
2. Right-click the Excel 2016 button in the Apps list on the left side of the screen.
On a touchscreen device, the equivalent to the right-click of the mouse is to tap and hold the Excel 2016 menu item until a circle appears around your finger or stylus. Then, when you remove your finger or stylus from the screen, the shortcut menu appears.
3. Select the Pin to Start option from the menu bar that appears at the bottom of the screen.
After pinning an Excel 2016 tile to the Windows 8 Start screen, you can move it by dragging and dropping it in your desired block.
When starting Excel 2016 from the Windows 7 Start menu, you follow these simple steps:
1. Click the Start button on the Windows taskbar to open the Windows Start menu.
To select the Start button on a device equipped with a mouse, you click the button. To select the Start button on a touchscreen device with no mouse or touchpad, you tap the button on the touchscreen.
2. Choose All Programs from the Start menu, choose Microsoft Office 2016, and then choose Excel 2016.
You can use the Search Programs and Files search box on the Windows 7 Start menu to locate Excel on your computer and launch the program in no time at all:
1. Click the Start button
