The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Project Training and help » Exporting to Excel

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Exporting to Excel

Resolved · High Priority · Version 2003

ReplyFri 5 Sep 2008, 14:53Delegate Cheryl said...

Exporting to Excel

Is there any way to export a report to excel?
I need to produce a list of tasks for all resources & have found a custom report entitled "To Do List" which suites my purpose. However I would like to export this information to excel. Can anyone help please?

For upcoming training course dates see: Pricing & availability

ReplyTue 9 Sep 2008, 12:41Trainer Andrew said...

RE: Exporting to Excel

Hi Cheryl

Thank you for your question. There is no way to convert a report to excel. An alternative would be to filter the chart to show the tasks you are interested in (Project > Filtered for > Using Resource) then click the select all square (above the row numbers and to the left of the column names). From the edit menu choose Copy Cell and switch to Excel. Paste the contents of the clipboard into Excel and you will have just the filtered tasks for your chosen resource.

I hope this helps.

Kind regards, Andrew

MS Project articles

· Learn To Use The Project Guide In Microsoft Project
· Using Microsoft Project To Perform Important Tasks
· Finding Your Way With The Project Map
· How To Use The New Timeline View In Project 2010
· Microsoft Project Server vs. Microsoft Project

Please browse our web site to find out more about
microsoft/project/courses and other Microsoft training courses.

Ms project tip:

Autofit column width – Project (all versions)

a. Highlight the column or columns you wish to alter the width of.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Project to automatically set the column width to fit the contents of the column (autofit)

View all MS Project hints and tips

When formatting cells, is there a way of chosing from a wider colour range. The colour options I can see are quite flashy...

» Forum post: Formatting cells

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions