iYogi

Home » Latest, TechGenie Answers, Technology » How to Make a Schedule in Excel

How to Make a Schedule in Excel

If you want to create a spreadsheet, calculate numbers by using formulas, or make a chart, there is hardly a more efficient application than MS Excel. But other than using it for the above purposes, Excel serves as a great tool for organizing in general. Apart from using Excel for generating agendas, creating calendars and building inventories, or to make employee time sheets, an easily readable schedule can also be made for all employees in an organization.

Microsoft ExcelInstructions to make a schedule in Excel

To make a schedule in MS Excel is a fairly easy and simple task as the necessary formats are already in place and once the basic template is built, many different schedules can be made for a wide and different variety of applications. In order to create an MS Excel schedule, you are required to go through the following steps.

Step 1: Of course, the first step is to open the Excel application. In case you are using Excel 2007, click on the ‘Office’ button; however if an older version of Excel is installed in your computer, click on ‘File’ and then select ‘New’.

Step 2: In the ‘Templates’ pane in Excel 2007, click on ‘Microsoft Online’; in case of Excel 2003 or older versions, search for the ‘Templates’ section of the task pane. In the box that says ‘Search online for’, type ‘schedule’ and then click on ‘Go’.

Step 3: To preview a schedule template, click on it and when you have found the one that meets your requirements, click on the ‘Download’ button. The schedule would then open as a new Excel worksheet.

Step 4: After this, change the existing text that is there in the schedule template. It is done by double clicking on the cell that contains the text needed to be altered. The existing text is selected using the mouse or by pressing the ‘Ctrl’ and ‘A’ keys together on the keyboard. The existing sample text is then typed over with the information you need on the schedule.

Step 5: The next step requires modifying the color of a cell. It is done by clicking on the cell to select it, and then by right clicking and choosing ‘Format Cells’. In the ‘Patterns’ tab, select the particular hue that you want in the ‘Cell Shading Color’ section. Click on the color and select OK for applying it to the cell.

Step 6: The font in any cell is then adjusted by clicking on it to activate it. Then right click on it and choose ‘Format cells’, go to the ‘Fonts’ tab, and choose a font type, size, color and style. Apply any effects you choose and click on OK.

The schedule is thus made in Excel. To save it, you can press ‘Ctrl’ and ‘S’ keys and provide a name to the worksheet and then navigate to the location where you want to save it.

Harmeet

About Harmeet


loves to simplify technology for all readers who are interested in the genre but find it complex to comprehend. She is a writer by passion and wants to enrich the life of others by writing about the latest gadgets, apps, and devices in the simplest and the most useful manner. Her blogs are detailed, interesting, and definitely fun to read…


Experience the Best Computer Support

Leave a comment

*