hidden columns
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Project Training and help » Hidden columns

Hidden columns

resolvedResolved · Low Priority · Version Standard

replyReply Fri 28 Mar 2008, 10:26Delegate Linda said...

Linda has attended:
Project Introduction course

Hidden columns

I am reviewing a project plan that someone else has sent me and I want to view all the columns and not just those sent in the view. How do I know what other columns may have data in them without going through all the additional column options one by one and adding these.

For upcoming training course dates see: Pricing & availability

replyReply Sun 18 May 2008, 17:23Trainer Alan said...

RE: Hidden columns

You could export the project to Excel. Create a data map to export all Project fields. All data will be exported to Excel and you can see it there.

Remember however that Excel 2003 and earlier have only 256 columns, so you will have to export in two hits as the data is exported to columns not rows.

Excel 2007 has unlimited columns so it works in one go.

 

Please browse our web site to find out more about
ms project server consultancy and other Microsoft training courses.

Ms project tip:

Use Autofill in MS Project

a. Complete 1st entry
b. Select cell with entry to be copied
c. Click & drag autofill handle over the lines to also contain the same information. (the autofill handle is the little black square in the bottom right hand corner of the heavy lack outline on the selected cell)

View all MS Project hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard