How to Define a Table in Excel 2007
Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007.
Other People Are Reading
Instructions
-
-
1
Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.
-
2
Click on the "Insert" tab at the top of the document.
-
-
3
Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.
-
4
Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.
-
5
Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.
-
6
Hit the "OK" button at the bottom of the Create Table dialog box to create your table.
-
1
Tips & Warnings
Use the shortcut Ctrl+T to bring up the Create Table dialog box after selecting your data range. This bypasses having to go to the Insert tab to find it.
After you create your table, a "Table Tools" tab appears on the toolbar that gives you tools for working with the data in your table.
Resources
More Like This
Comments
-
I would like to define the size of the table from a cell reference. I.e. if I chage the cell reference for number of row from say 5 to 10, then table will also expand to 10 rows. Is this possible?
