98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » Microsoft Project
Microsoft Project
Resolved · Low Priority · Version 2003
Steven has attended:
Excel Introduction course
Microsoft Project
Why would I copy a Gantt reports into an Excell document rather than a word document?
RE: Microsoft Project
Hi Steven
Both work equally well. Excel is good for pasting the data tables, Word for pasting the copied picture of the Gantt Chart. For example to copy the table to Excel first click on the square above the row number 1. This selects all the tasks in the table. From the edit menu choose Copy task and switch to Excel.
Click in the first sheet and from the Edit menu choose paste. The table is pasted into the cells.
If you would like to avoid including summary tasks in the pasted data change a setting in Project before copying. From the Tools menu choose Options and the View tab. At the bottom of the dialog box remove the tick from Show summary tasks. Then copy and paste as before.
I hope this helps - let me know if you have any further questions.
Kind regards,
Andrew
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Using the Quick Access Toolbar in Project 2010The Quick Access Toolbar is included in virtually every Office product, including Project 2010 as well as Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010. |