Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft project

ResolvedVersion 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

MS Project tip:

Giving Someone a Gantt Chart Snapshot

To pass on a picture of a Gantt chart segment, choose the appropriate view, select the rows to be included, then click on the camera icon and select For Screen. The graphics image can be pasted into another document. (See Paste icon forn Project 2010)

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.