How to make a schedule in excel

Written by tricia goss Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to make a schedule in excel
Schedules can be colour coded and organised in Microsoft Excel.

Microsoft Excel is a great application to use if you need to create a spreadsheet, make a chart or calculate formulas. However, you may not realise that Excel is also a helpful tool for organising in general. Besides using Excel to generate agendas, make employee time sheets, create calendars and build inventories, you can also make an easily readable schedule for all of your employees.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Open Microsoft Excel. click the "File" menu and choose "New."

  2. 2

    Go to the "Available Templates" section and the Office.com Templates area.

  3. 3

    Preview a schedule template by clicking on it. Once you have found the one that fits your requirements, click the "Download" button. The schedule will open as a new Excel worksheet.

  4. 4

    Change existing text in the schedule template by double-clicking on the cell that contains the text you want to alter. Select the existing text using your mouse or the keyboard shortcut "Ctrl-A." Type over the existing sample text with the information you need on the schedule.

  5. 5

    Modify the colour of a cell by clicking the cell to select it. Right-click and choose "Format Cells." Go to the "Patterns" tab and choose the hue you want in the Cell Shading Color section. Click the colour and click "OK" to apply it to the cell.

  6. 6

    Adjust the font in any cell by clicking the cell to activate it, and right-clicking and choosing "Format Cells." Go to the "Fonts" tab and choose a font type, style, size and colour, and apply any effects you choose. Click "OK" to apply the changes.

  7. 7

    Press "Ctrl-S" to save your schedule. Provide a name for the worksheet and navigate to the location where you want it saved.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.