Microsoft Office Tutorials and References
In Depth Information
To Enter the Column Headings for a Table
Create and format the sales rep table.
One way to create a table in Excel is to follow these ﬁ ve steps: (1) enter the column headings
(ﬁ eld names); (2) deﬁ ne a range as a table using the Format as Table command; (3) format the
insert row immediately below the column headings; (4) set up data validation using the Data
Validation command; and (5) enter records into the table. The following pages illustrate the
process of creating the Silver Photography Accessories Sales Rep table using these ﬁ ve steps.
The following steps change the column widths to those speciﬁ ed in Table 5–1, enter
the table title, and enter and format the column headings. These steps also change the
name of Sheet1 to Sales Rep Table, delete the unused sheets in the workbook, and save
the workbook using the ﬁ le name, Silver Photography Accessories Rep Table.
Although Excel does not require a table title to be entered, it is a good practice to
include one on the worksheet to show where the table begins. With Excel, you usually
enter the table several rows below the ﬁ rst row in the worksheet. These blank rows later
will be used as a criteria area to store criteria for use in a query.
Setting Up a List
When creating a list,
leave several rows empty
above the list on the
worksheet to set up a
criteria area for querying
the list. Some spread-
sheet specialists also
leave several columns
empty to the left of the
list, beginning with
column A, for additional
worksheet activities. A
range of blank rows or
columns on the side of a
list is called a moat of cells.
The majority of tasks involved in entering and formatting the table title and column
headings of a list are similar to what you have done in previous chapters. Thus, if you plan to
complete this chapter on your computer and want to skip the set of steps below, open the
workbook Silver Photography Accessories Sales Rep Table from the Data Files for Students.
1 Use the mouse to change the column widths as follows: A = 16.43, B = 11.57, C = 8.29,
D = 13.14, E = 9.43, F = 14.00, G = 13.29, H = 13.29, I = 14.57, and J = 10.29.
2 Enter Silver Photography Accessories Sales Rep Table as the table title in cell A7.
3 Apply the Title cell style to cell A7. Click the Font Color button on the Home tab on the
Ribbon and then click Red, Accent 2 (column 6, row 1) on the Font Color palette.
Merging and Centering
Across a Selection
You merge and center
when you want to treat
the range of cells over
which you center as a
single cell. You center
across a selection when
you want the selected
range of cells to be
independent of one
another. With most
workbooks, it makes
little difference whether
you center using one
technique or the other.
Thus, most spreadsheet
specialists use the merge
and center technique
because the procedure is
available as a button on
the Home tab on
4 Select the range A7:H7. Right-click the selected range and then click Format Cells on the
shortcut menu. When Excel displays the Format Cells dialog box, if necessary, click the
Alignment tab, click the Horizontal box arrow in the Text alignment area, click Center
Across Selection in the Horizontal list, and then click the OK button.
5 Enter the column headings in row 8 as shown in Figure 5–4. Center the column headings
in the range B8:H8.
6 Apply the Heading 3 cell style to the range A8:H8.
7 Double-click the Sheet1 tab at the bottom of the screen. Type Sales Rep Table as the
sheet name. Press the ENTER key. Right-click the tab, point to Tab Color on the shortcut
menu, and then click Red, Accent 2 (column 6, row 1).
8 Click the Sheet2 tab, hold down the CTRL key, and then click the Sheet3 tab. Right-click
the selected sheet tabs and then click Delete on the shortcut menu to delete the selected
sheets from the workbook.
9 Update the document properties with your name and any other relevant information.