Excel 2019 Bible

(singke) #1

Chapter 5: Formatting Worksheets


55


FIGURE 5.2


The Mini toolbar appears above or below the right-click shortcut menu.


If you use a tool on the Mini toolbar, the shortcut menu disappears, but the toolbar remains
visible so that you can apply other formatting to the selected cells. To hide the Mini tool-
bar, just click in any cell or press Esc.


Using the Format Cells dialog box


The formatting controls available on the Home tab of the Ribbon are sufficient most of the
time, but some types of formatting require that you use the Format Cells dialog box. This
tabbed dialog box lets you apply nearly any type of stylistic formatting and number for-
matting. The formats that you choose in the Format Cells dialog box apply to the selected
cells. Later sections in this chapter cover the tabs of the Format Cells dialog box.


After selecting the cell or range to format, you can display the Format Cells dialog box by
using any of the following methods:


■ (^) P ress Ct rl+1.
■ Click the dialog box launcher in Home ➪ Font, Home ➪ Alignment, or Home ➪
Number. (The dialog box launcher is the small downward-pointing arrow icon

Free download pdf