I understand wanting to have a well formatted schedule in Excel.
What I have done in the past is include all the columns I need; Unique ID, Task Name, % Complete, Duration, Start Finish.
I also add the columns Outline Level and Summary. I then use the Outline level column in Excel to create a formula for indentation. I use the Summary column to have a conditional format that will change the color and bold all my summary task rows.
I've attached an image so it makes better sense. You can see in the formula bar the formula I used for the task name with indentation.
This makes a great difference for my users.
|