How to Make a Timeline in Microsoft Excel

This tutorial will show you how to create a timeline in Excel.

Don't forget to check out our site howtech.tv/ for more free how-to videos!
youtube.com/ithowtovids - our feed
facebook.com/howtechtv - join us on facebook
plus.google.com/103440382717658277879 - our group in Google+

In this tutorial you are going to learn how to create a timeline in Excel.

Step # 1 -- Entering the Information

Start Excel and you are first going to need to enter the dates that are relevant to your timeline. In the row above this write in the information that you want to associate with the date, each bit of information should be in the corresponding column.

Step # 2 -- Formatting the Dates

Now that we have our information we are just going to need to add some formatting to the timeline to make it look good. Let's start with the dates, select them and then bold them and increase the size of the text a little. We are also choosing to centralize the text and add a background color and border. How you format this will really depend on your preferences.

Step # 3 -- Formatting the Event Details

Now we are going to format the information above the dates so it is easier to read. Select these cells and make sure you are in the "Home" tab. From the "Alignment" area click the "Orientation" icon and select "Angle counterclockwise" from the menu that appears. Now we are going to add some formatting to this text, add a border and a background color. You should also centralize the text and that is pretty much it, you now know how to do a timeline in Excel.