Microsoft Office Tutorials and References
In Depth Information
To Format a Range as a Table
To Format a Range as a Table
The following steps defi ne the range A8:H8 as a table by applying a table quick style to the range. Excel allows
you to enter data in a range either before defi ning it as a table or after defi ning it as a table. This chapter uses the latter
procedure because it offers additional tools that help ensure data integrity, such as data validation.
1
Select the
range A8:H8.
Format
as Table
button
Click the Format as
Table button on the
Home tab on the
Ribbon to display the
Table Style gallery
(Figure 5–5).
I
Experiment
Point to a number of
table quick styles in
the Table Style gallery
to preview them on
the worksheet.
column
headings in
range A8:H8
selected
Table Style
Medium
2 quick
table style
2
Click the Table Style
Medium 2 quick
table style in the
Table Style gallery.
Table
Style
gallery
When Excel displays
the Format As Table
dialog box, click the
‘My table has
headers’ check
box to select it
(Figure 5–6).
Why is the range
A8:H8 already
selected in the
Format As Table
dialog box?
Because the
range A8:H8 was
selected before click-
ing the Format As
Table button, Excel
automatically selects
this range for the
‘Where is the data
for your table?’ box.
Figure 5–5
Format
As Table
dialog box
Excel automatically
selects highlighted
range
My table
has headers
check box
selected
OK button
Figure 5–6
 
 
Search JabSto ::




Custom Search