Page 143 - Ms Excel Note and Workbook
P. 143
MICROSOFT EXCEL NOTE AND WORKBOOK
12 TABLES
Format Data as a Table
1. Select the cells you want to format as a table. In our example, we'll select the cell
range A2:D9.
TIP
Tables include filtering by
default. You can filter your
data at any time using the
drop-down arrows in the
header cells.
2. From the Home tab, click the Format as Table command in the Styles group.
3. Select a table style from the drop-down menu.
4. A dialog box will appear, confirming the selected cell range for the table.
5. If your table has headers, check the box next to My table has headers, then click OK.
6. The cell range will be formatted in the selected table style.
134 | P a g e
