Problem:
    When you copy Project tasks of a Project Plan from Microsoft Project to Excel, You loose all the beautiful indention. The below images illustrates the problem
    Project Plan in MPP:
    Same Project Plan when pasted in Excel :
    Solution:
    I have created this Excel template where you can paste your MPP tasks and it will automatically be perfectly indented. Here are the solution steps
  1. Download the Excel Template from here.
  2. Show your desired level of task details in Microsoft Project by clicking "Show" Drop down on Formatting Toolbar
  3. Make sure you have "Outline Level" Column shown in Micorosft Project. (insert -> Column -> Outline Level)
  4. Copy whole tasks column from MPP in Cell H2 of Excel
  5. Copy whole Outline Level column from MPP in Cell I2 of Excel
  6. You're Done ;). Check Column A
    7. Indented Plan should look like:
    Optionally you can,
  7. Hide Column H,I,J & K in excel Sheet
  8. Configure the Indentation width from Cell K2
  9. Paste as many additional columns from MPP to Excel as you want (e.g. Duration, Resources etc)
  10. Copy/paste the indented columns from Excel to Word if you want to use project plan in MS Word
    11. How I achieved this:
  11. Indention have been achieved using the formula "=REPT(" ",Identation_Width*I2) & H2" in Column A
  12. Summary Tasks have been made bold using Conditional formatting formula (I1>I2)on Column A.