advanced excel course london - Adding columns

Resolved · Low Priority · Version Standard

Thu 26 Jul 2007, 12:43 Delegate Thomas said...

Thomas has attended:
Excel Introduction course

Adding columns

How do I add a blank column in the middle of a table of information?

Thu 26 Jul 2007, 16:27 Trainer Amanda said...

RE: Adding columns

Hi Thomas

Thanks for your question.

You can do this by selecting the column to the right of where you want to insert the new column, then right-click above the selected column and choose Insert.

Note you have to select the whole column by clicking on the letter above the column for this to work.

Amanda

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips

advanced excel course london - Adding columns

Adding columns

RE: Adding columns

Excel articles

Excel tip:

Calculate age or service