Monday, February 20, 2012

How to Make a Time Line in Excel 2003


1. Open a blank worksheet in Microsoft Excel. Click 'View' on the toolbar and click 'Header and Footer'. The 'Page Setup' box will open. Click the 'Custom Header' button and enter the header you want printed on your page. Format it using the 'Font' button. Click 'OK' to close the 'Header' box, but don't close the 'Page Setup' box.
2. Click the 'Page' tab of the 'Page Setup' box. Under 'Orientation', select the 'Landscape' button. Click 'OK' to close the 'Page Setup' box.
3. Select all of the cells on your current page in row 7 using your mouse. Click on the 'Fill Color' button on your toolbar (which looks like a pouring paint can) and choose a fill color for those cells.
4. Select all of the cells in row 6 by clicking on the number 6 with your mouse. Right-click and choose 'Format Cells'. Click the 'Alignment' tab of the 'Format Cells' box. Under 'Orientation', move the 'Text' to 90 degrees. If desired, click the 'Font' tab and make changes to the font for those cells. Repeat these steps for row 8, except change the 'Text Orientation' to -90 degrees. This will align your text up and down from the timeline bar.
5. Enter times in the bar itself and enter data in the corresponding cells in rows 6 and 8. If desired, you can add clip art pictures by going to the 'Insert' menu, pointing to 'Pictures' and clicking on 'Clip Art'. Search and enter pictures that suit your timeline. When you are finished, you can print your personalized timeline.

Blogger news