Page 157 - Excel 2013 All-in-One For Dummies

Formatting Tables from the Ribbon 139
✦ To change the height of a row in the Row Height dialog box: Choose Row Height from the Format button’s drop-down menu in the Cells group of the Ribbon’s Home tab and then enter the value for the new row height in the Row Height text box before you click OK or press Enter.
✦ To hide a row: Position the cell cursor in any one of the cells in that row and then click the Format button in the Cells group on the Home tab before you choose Hide & Unhide➪Hide Rows from the drop-down menu (or press Alt+HOUR). To then restore the rows that you currently have hidden in the worksheet, click the Format button and then choose Hide & Unhide➪Unhide Rows from the drop-down menu (or just press Alt+HOUO instead).
As with adjusting columns, you can change the height of more than one row and hide multiple rows at the same time by selecting the rows before you drag one of their lower borders, open the Row Height dialog box, or choose Format➪Hide & Unhide➪Hide Rows on the Home tab, or press Alt+HOUR.
Formatting Tables from the Ribbon
Excel 2013’s Format as Table feature enables you to both define an entire range of data as a table and format all its data all in one operation. After
you define a cell range as a table, you can completely modify its formatting simply by clicking a new style thumbnail in the Table Styles gallery. Excel also automatically extends this table definition — and consequently its table formatting — to all the new rows you insert within the table and add at the bottom as well as any new columns you insert within the table or add to either the table’s left or right end.
The Format as Table feature is so automatic that, to use it, you only need to position the cell pointer somewhere within the table of data prior to clicking the Format as Table command button on the Ribbon’s Home tab. Clicking the Format as Table command button opens its rather extensive Table Styles gallery with the formatting thumbnails divided into three sections — Light, Medium, and Dark — each of which describes the intensity of the colors used by its various formats. (See Figure 2-5.)
As soon as you click one of the table formatting thumbnails in this Table Styles gallery, Excel makes its best guess as to the cell range of the data table to apply it to (indicated by the marquee around its perimeter), and the Format As Table dialog box similar to the one shown in Figure 2-6 appears.
This dialog box contains a Where Is the Data for Your Table? text box that shows the address of the cell range currently selected by the marquee and a My Table Has Headers check box (selected by default).
Book II Chapter 2
Formatting Worksheets