MS Project: Show ALL Columns / Fields

Nanogirl21

Active Member
Joined
Nov 19, 2013
Messages
331
Office Version
  1. 365
Platform
  1. Windows
I have a project that has 190 columns/fields hidden. Is there a VBA Macro or easy way to unhide all columns/fields? I can manually add each column and save a custom view for next time, but that is very time-consuming.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
I know what an Excel column is. But not sure what a field is.
Excel has columns and rows.

So, assuming you mean columns: What columns do you want to unhide or show?

Excel has several thousand columns I do not think you can hide all of them
 
Upvote 0
Look to record a macro in your project to unhide at least one field/column which will provide the basics of what you want. Do you know which fields are hidden? And in what element of the project as there are many parts (views, schedules, tasks etc).

You could then post your code here which will help someone providing a solution for you.
 
Upvote 0
By the way once you hide columns to show them again you would need to insert a column then find the name you have used/created as well as deciding where it should be positioned.
 
Upvote 0

Forum statistics

Threads
1,223,896
Messages
6,175,263
Members
452,627
Latest member
KitkatToby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top