Wednesday, September 08, 2010

Microsoft Project 2010: Outline Number and Fill Down

I was recently updating a Microsoft Project file and encountered a couple items worth mentioning.

First, by inserting a column called "Outline Number," Project automatically populates the Work Breakdown Structure (WBS) task ID (WBS column does the same thing). This is much better than doing it manually.

Secondly, Microsoft Project doesn't let you paste a value into a range of cells like Excel. So, instead of manually typing in durations or pasting one at a time, there is a "Fill Down" menu option. Select the cell that contains the value you want, select the range, right-click, and select "Fill Down."

This will fill in the range with the source value.

No comments:

Blog Archive