In Microsoft Project, there are hundreds of fields, or columns of data, that you can view and enter information into. To avoid having to scroll through all of these columns to find a specific piece of information, Project organises its fields into tables.
A table is a preset collection of related fields that you can choose to display depending on which view you are in. Inevitably, you’ll find that you won’t use every field in a particular table, that you’ll hide some of them, or that some tables don’t have all the fields you require and that you’ll have to insert them. You might even create your own custom fields that you want to add to existing tables. This isn’t an issue the first couple of times you do it, but if you find yourself having to insert and delete columns every time you create a new project it might be time to consider creating a custom table.
Existing Tables in Project
As we mentioned above, there are several preset tables within Project and a number of ways to switch between them:
- In any version of Project you can right-click at the top left corner of a table and choose a different table view.
- In Project 2003 and 2007, from the menu you can choose View -> Table: and then select a different table view.
- In Project 2010, from the View tab of the Ribbon you can choose Tables and then select a different table view.
Seeing the Full List of Preset Tables
The list of tables shown above is merely a shortlist of the most commonly used tables in Project. To get access to the full list of preset tables you’ll need to delve a little deeper.
- Right-click at the top left of the current table and choose the option shown below.
- In the More Tables dialog box that appears you will see the full list of available tables.
Creating a Custom Table
You can create a custom table using the More Tables dialog box.
- Display the More Tables dialog box, as described above.
- Click the New… button to begin creating a new table.
- Complete the dialog box shown below.
- Type in a name for your table.
- Check this box to ensure that your table appears in the list of commonly used tables.
- Use the drop list to select the fields you want to include in your table.
- Fill in the other options for each field as appropriate.
- Click OK to create the table.
Using Your Custom Table
Once you’ve created a table you can choose to display it in the same way as choosing to display a preset table.
- If you checked the box shown in Step 5 above you’ll see your table in the list of commonly used tables.
- You can also see your custom table in the More Tables dialog box.
Using Your Table in Other Projects
When you create a custom table it will only be available in the project you are working on. To make sure that you can use your table in other projects you’ll need to use the Organizer tool to copy it into the Global project template. This blog explains how to do this.