Insert A Column

Download starting Sheet

I now want to calculate how many days ago I spend the money, but I forgot to add a heading for that. I'll need to insert a column.

Steps:

1. Select cell F1
2. Press CTRL + SPACE
3. Press CTRL + SHIFT + +
4. Type: "Days Ago" in F1

NOTE:

• Inserting a column does not affect the formulae we have entered
• Excel cleverly preserves the formatting

Your sheet should now look like this

Next Lesson: Teach Yourself Excel Lesson 16 - Absolute References

Training Video on how to insert a column in Excel: