Creating a Timeline in Excel

1
Creating a Timeline in Excel
0
L E S S O N P L A N I D E A
2
Sample
0
3
Online Resources and Directions
0

• http//faculty.musowls.org/RutledgeJ/Excel_timelin
  e.htm
• http//www.microsoft.com/education/CreateTimeline.
  aspx
• http//www.edzone.net/mwestern/tutorials/timeline
  ex.pdf

4
STEP 1
0

• Open an Excel Workbook
• Select File, the Page Setup
• Choose landscape orientation
• Click OK

5
STEP 2
0

• Type the Title of your timeline in cell A1
• Select Cells A1 to M1
• Merge the Cells

6
STEP 3
0

• Start your timeline in cell A3
• Use colors and/or merge cells to indicate
  blocks of time on the timeline
• See sample
• Add all of the years in row 3

7
STEP 4
0

• Highlight row 2
• Choose format, then cells
• Put a check in the wrap text box
• Change the text orientation to 75 degrees

8
STEP 5
0

• Add the timeline events in row 2 above the
  correct year in row 3
• Change text size and color if desired

9
STEP 6
0

• In row 4, add pictures or hyperlinks to match the
  events (if desired).
• To add a picture, choose Insert, picture, from
  file
• To add a hyperlink, click in the cell where you
  want the hyperlink to appear. Then, choose
  Insert, hyperlink. Type or paste the link here.