Microsoft Project

Resolved · Low Priority · Version 2003

Mon 26 Jan 2009, 16:05 Delegate Steven said...

Steven has attended:
Excel Introduction course

Microsoft Project

Why would I copy a Gantt reports into an Excell document rather than a word document?

Tue 27 Jan 2009, 16:20 Trainer Andrew said...

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 courses

	98.7 % recommend us
	More live stats...

Training information:

MS Project tip:

Using the Quick Access Toolbar in Project 2010

The 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.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all MS Project hints and tips