Creating table in 2007 Microsoft Excel worksheet permits to divide set of linked data from other data on worksheet. Every table or list can be handled separately with individual headings, totals and formatting. In 2007 Excel, you can make tables by inserting them into worksheet or just reformatting them into table. Making and changing tables or lists in Excel is easy and can be achieved in some steps.
Inserting Tables In 2007 Excel
Choose range of cells to add in table. These cells may have data or be empty.
Choose "Tables" from "Tables" menu below Insert tab.
A pop-up titled "Create Table" will show and will ask what data will be utilized in this table. The variety of data chosen earlier will show in this field. To change this range, click on icon to right of field and again choose data for table. If data has headers, ensure to check box to make headers for table.
Click "OK" to generate table. After generated, table will be colored to differentiate it from remaining worksheet.
Change settings of table by "Design" tab. From menu, you do modifications like pick new table style, include header and pick for stripy rows or columns for reading.
Formatting Data as Tables in 2007 Excel
Select a variety of data you would like to change into a table.
From "Home" tab, select "Styles" group. Pick "Format as Table."
Medium and dark table styles.
Utilize "Design" menu to change table as wanted.
Creating Lists in Earlier Versions of Excel
Highlight data to add in list.
"Data" menu, go to "List," and then make "Create List."
If list has headers, select "My list has headers".
Press "OK" to create list. After made, it will be divided from remaining worksheet with blue border.
Change list using "List" toolbar.