Microsoft Office Tutorials and References
In Depth Information
DEFINE DATA
as a table
A table is a set of columns and rows where each
column represents a single type of data. For example,
your table might have three columns: name, gender,
and age. For each row in your table, the name
column contains a name, the gender column contains
a gender, and the age column contains an age. You
can define worksheet rows and columns as a table.
When you define rows and columns as a table, sort
and filter drop-down lists are automatically added to
each column head, enabling you to readily sort and
filter your data. Defining a table is simple. In fact, you
can define an existing worksheet as a table. Before
you start, make sure your data is arranged in columns
and rows, each with a descriptive column head.
Defining rows and columns as data also makes Design
tools available. You can use the design tools to format
your table quickly.
You should avoid blank cells and blank spaces at the
beginning of a table cell because they make sorting
difficult.
2
1
Click and drag to select the data
you want to define as a table.
Include column heads.
3
2
Click the Insert tab.
3
Click Table in the Tables group.
1
The Create Table dialog box
appears.
l
The data range you selected
appears here.
l
4
Click here if your table has
headers (
changes to
).
5
Click OK.
4
5
104
 
Search JabSto ::




Custom Search