Microsoft Office Tutorials and References
In Depth Information
Convert a Range to a Table
Working with Tables
The Create Table dialog
box appears.
A Excel selects the range
that it will convert to a
B If you want to change
the range, click , drag
the Excel mouse pointer
( ) over the new range,
and then click .
4 If your range has labels
that you want to use as
column headers, click
My table has headers
changes to
5 Click OK.
Excel converts the range
to a table.
C Excel applies a table
format to the range.
D The Table Tools
contextual tab appears.
E Filter buttons appear in
each column heading.
6 Click the Design tab to
see the Excel table
design tools.
Do I need to add labels to the top of each
column before converting my range to a table?
No. In this case, follow Steps to to display 3
the Create Table dialog box, then click My
table has headers ( changes to ). After
you click OK, Excel converts the range to a
table and automatically adds headers to each
column. These headers use the generic names
Column1, Column2, and so on.
If I selected the wrong range for my table, is
there a way to tell Excel the correct range?
Yes. First select any cell in the table.
Under the Table Tools contextual tab, click
the Design tab and then click Resize Table
( ) to open the Resize Table dialog box.
Drag the mouse
over the new range and
then click OK.
Search JabSto ::

Custom Search