Microsoft Office Tutorials and References
In Depth Information
Chapter 12: Managing Lists and Data
originally created in Excel 2003 that contains one or more lists, you’ll need to manually
convert those lists to tables.
To turn a range into a table, select the range (or select any cell within the range if the list
is in a self-contained region), and then click Table in the Tables group on the Insert tab (or
use the keyboard shortcut Ctrl+T or Ctrl+L). You’ll see the Create Table dialog box shown in
Figure 12-1.
Figure 12-1 Even though we selected only a single cell, Excel expands the selection to include
the entire data-containing region, as defined by blank rows and columns.
Had we instead clicked Format As Table, in the Styles group on the Home tab, we would
have been required to select a table style before seeing the Create Table dialog box (which
in this case is named Format As Table). Using either keyboard shortcut applies the default
table style. (We discuss table styles in much greater detail in “Formatting and Using Tables”
on page 391.)
Excel correctly detected that this range contains a header row with labels for each
column and selected the My Table Has Headers check box. (For the most part, Excel correctly
detects the presence of headers, but it can be confused by some configurations, so check
this setting before you proceed.) Clicking OK applies the default table style to the range
and makes a few other changes. The end result looks like this:
Search JabSto ::




Custom Search