This video shows how to create field lookup tables in Microsoft Project.
- [Instructor] With a lookup table, … you can enter data quickly and without errors. … To create a lookup table, … right click the custom field heading in a table … and then choose custom fields. … The custom fields dialog box opens … and selects the custom field you right clicked. … Beneath the field list, click lookup. … In the value cells, … add the standard values for the field. … Press enter after you enter each value. … You can add descriptions if you want to provide context. … To set a default value, … turn on the check box labeled use a value from the table … as the default entry for the field. … Click the value in the list … and then click the set default button. … The default value turns blue. … When you create a new task, … Project fills in the default value automatically. … When you're done with a lookup table, click close, … and then click okay. … To use a lookup table, … click the cell and then click its down arrow. … When the dropdown list appears, … click the value you want. …
- Working faster in Microsoft Project
- Entering data
- Using keyboard shortcuts
- Formatting tables
- Modifying views
- Sorting and Filtering
- Working with Files
- Backing up
- Sharing customization with a colleague
Skill Level Intermediate
1. Project Quick Tips
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.