Logo
programming4us
programming4us
programming4us
programming4us
Home
programming4us
XP
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Windows Phone
 
programming4us
Windows 7

Microsoft Project 2010 : Adding and Removing Columns in a View

12/26/2011 4:19:46 PM
The process of adding and removing columns in views in Project 2010 is incredibly easy. However, the concept behind what happens sometimes can be confusing, so before we get into how to add and remove columns, let’s talk a bit about what’s going on behind the scenes.

It’s important to remember that behind the shiny interface of Project 2010, there’s a database. A nice, stable, giant database. When you use Project to add information about your project, that information makes its way into that database. In the Project interface, you use views to look at the data in that database, as illustrated in Figure 1. Views are set up to slice and dice the information in the database, in a way that helps make sense of it. Columns are just parts of views. They’re a way of surfacing specific parts of the database.

Figure 1. The Project window uses views to access data in the Project database.

The confusion around this often comes when you go to remove a column from a view. Let’s say you’ve had a column in a view for a long time and data has been added to the column. You decide you no longer need that data, so you hide the column in the view. Then later, you decide you want to use that column for another purpose, so you add it again, and lo and behold your data is still in there. This sometimes comes as a rude surprise to some Project users, who thought that by hiding the column, the data would go away.

When you hide a column, that’s really all you’re doing. You’re taking that way of viewing information in the database out of a view. Imagine if you were simply trying to change which view surfaced the information. Let’s say you had a column of information in one view, and after you had been using it for a while, you realized it would be better suited for another view. If you had to re-create the column with its data in another view, it could really become quite an effort if you had a large project with several hundred rows of data.

So if columns are just a way to surface information in the database, how do you remove the data from the database altogether? Select the cells in a column that contain the data you want to delete and then press Delete. Got a lot of rows? Click the first cell in the column, scroll to the last row in the table, press and hold Shift, click the last cell in the column, and then press Delete. Poof, your data is gone.

This might be a good time to point out that Project supports multiple undo levels. That is, you can undo things you did several actions ago by clicking Undo or pressing Ctrl+Z multiple times. You can set how many undo levels you want to support on a project. On the File tab, click Options. Click Advanced. Under General, type the number of undo levels you want to support in the Undo levels box and then click OK.


Adding a Column to a View

In any view with data displayed in a table, such as the Gantt Chart view, simply scroll to the right side of the table portion of the view and you’ll see the Add New Column header, as shown in Figure 2.

Figure 2. Click Add New Column to add a column to the current view.


To add a new column, click that header and then click the name of the column you want to add. After the column is added, you can click and drag it to relocate it within the view. Click the new column header to select the column and then use the four-direction arrow cursor to drag and drop the column within the view.

Alternatively, you can add a column exactly where you want it to appear. Right-click the column header for the column that you want to appear to the right of the column you’re adding and then click Insert Column. Click the name of the column to add it to the view.

Hiding a Column in a View

If you want to remove a column from a view without removing the data, click the column header to select the column and then press Delete. Alternatively, you can right-click the column header and then click Hide Column, as shown in Figure 3.

Figure 3. Right-click a column header and then click Hide Column.


With either of these options, the data that was entered in that column is not removed from your project. I really can’t emphasize this enough. If you want to remove the data, select the cells containing the data and then press Delete. You’ll see the data in the cells is no longer there after you press Delete. If you don’t actually see the data gone from the cells in the column, there’s a good chance it’s still sitting back there in the database. Consider this fair warning!

Other -----------------
- Metadata and Power Searches : Setting Properties When You Save & Personalizing Searches
- Metadata and Power Searches : Working with File Properties
- Tracking Your Licenses with the Key Management Service (part 2) - Configuring DNS to Let KMS Clients Find the KMS Server
- Tracking Your Licenses with the Key Management Service (part 1) - Installing and Initializing KMS
- Taking Advantage of Volume Licensing : Choosing the Right Volume License Key for Windows
- Windows 7 Kernel Mode Drivers Overview and Operations : KMDF I/O Model (part 2)
- Windows 7 Kernel Mode Drivers Overview and Operations : KMDF I/O Model (part 1) - I/O Request Handler
- Windows 7 Kernel Mode Drivers Overview and Operations : KMDF Object Model
- Windows 7 Kernel Mode Drivers Overview and Operations (part 2) - Device Objects and Driver Roles
- Windows 7 Kernel Mode Drivers Overview and Operations (part 1)
 
 
Top 10 video Game
-   Minecraft Mods - MAD PACK #10 'NETHER DOOM!' with Vikkstar & Pete (Minecraft Mod - Mad Pack 2)
-   Minecraft Mods - MAD PACK #9 'KING SLIME!' with Vikkstar & Pete (Minecraft Mod - Mad Pack 2)
-   Minecraft Mods - MAD PACK #2 'LAVA LOBBERS!' with Vikkstar & Pete (Minecraft Mod - Mad Pack 2)
-   Minecraft Mods - MAD PACK #3 'OBSIDIAN LONGSWORD!' with Vikkstar & Pete (Minecraft Mod - Mad Pack 2)
-   Total War: Warhammer [PC] Demigryph Trailer
-   Minecraft | MINIONS MOVIE MOD! (Despicable Me, Minions Movie)
-   Minecraft | Crazy Craft 3.0 - Ep 3! "TITANS ATTACK"
-   Minecraft | Crazy Craft 3.0 - Ep 2! "THIEVING FROM THE CRAZIES"
-   Minecraft | MORPH HIDE AND SEEK - Minions Despicable Me Mod
-   Minecraft | Dream Craft - Star Wars Modded Survival Ep 92 "IS JOE DEAD?!"
-   Minecraft | Dream Craft - Star Wars Modded Survival Ep 93 "JEDI STRIKE BACK"
-   Minecraft | Dream Craft - Star Wars Modded Survival Ep 94 "TATOOINE PLANET DESTRUCTION"
-   Minecraft | Dream Craft - Star Wars Modded Survival Ep 95 "TATOOINE CAPTIVES"
-   Hitman [PS4/XOne/PC] Alpha Gameplay Trailer
-   Satellite Reign [PC] Release Date Trailer
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 windows Phone 7 windows Phone 8
programming4us programming4us
 
Popular keywords
HOW TO Swimlane in Visio Visio sort key Pen and Touch Creating groups in Windows Server Raid in Windows Server Exchange 2010 maintenance Exchange server mail enabled groups Debugging Tools Collaborating
programming4us programming4us
PS4 game trailer XBox One game trailer
WiiU game trailer 3ds game trailer
Trailer game
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer