Hidden columns

The UK's most regular instructor-led training courses.
Training information: ms project server consultancy · Project training · Microsoft Project Training London
See also · microsoft project training courses · microsoft.project.course · microsoft+project+courses

Resolved · Low Priority · Version Standard

Hidden columns

Linda has attended:
Project Introduction course

by - delegate Linda [1 post] (2008 Mar 28 Fri, 10:26) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Project Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 10 Wed	Southwark	5	book now	£295	£345
2003	2009 Jan 27 Tue	Southwark	8	book now	£295	£345
2003	2009 Feb 23 Mon	Southwark	8	book now	£295	£345
2003	2009 Mar 23 Mon	Southwark	8	book now	£295	£345
2003	2009 Apr 27 Mon	Southwark	8	book now	£295	£345
2003	2009 May 26 Tue	Southwark	8	book now	£295	£345
Full Schedule: See all 13 Project Advanced course dates. Bookings currently available until 21st December 2009.

RE: Hidden columns

by - trainer Alan silver contributer [73 posts] (2008 May 18 Sun, 17:23) Reply

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.

· MS Project Courses: Taking your Business from Good to Exceptional in Just 3 Days
· Microsoft Project Training Courses
· Microsoft Project 2007: New Features
· Plan your wedding with the help of Microsoft Project
· Resource Management using Microsoft Project

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

Project tip:

Project Community

in the help menu type "Tips" then select "Ask the Project community" this takes you into microsofts site where you can ask questions to lots of knowledgeable people.They make up an online group of experienced Project users who answer questions and provide solutions and tips.

View all Project hints and tips