Friday, February 22, 2013

How to Make a Schedule in Excel


1. Open Microsoft Excel. click the 'File' menu and choose 'New.'
2. Go to the 'Available Templates' section and the Office.com Templates area.
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. 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. Modify the color 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 color and click 'OK' to apply it to the cell.
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 color, and apply any effects you choose. Click 'OK' to apply the changes.
7. Press 'Ctrl-S' to save your schedule. Provide a name for the worksheet and navigate to the location where you want it saved.

Blogger news