How to Create a Weekly 24 Hour Calendar With Excel
The easily viewed gridlines and multiple cell-formatting options of Microsoft Excel's worksheets make it the ideal application when you need to create calendars and schedules. Many free Excel calendar templates are available on Microsoft's website (link in Resources). But you can quickly create a calendar to keep track of your week, hour by hour, and format it to look just the way you want. It is especially easy when you know how to use Excel’s fill handle.
Other People Are Reading
Instructions
-
-
1
Open a blank worksheet in Excel. Select cells A1 through H1 by clicking on A1, holding down the mouse button and dragging the mouse over to H1. Go to the Cells section of the Home tab, click the "Format" drop-down arrow and select "Row Height." Change the row height to "26.25" and click "OK."
-
2
Type the word "Time" in cell A1. In cell B1, type "Monday." Click B1 to select it, then click on the fill handle, which is a small black square in the bottom right corner. Drag the fill handle across to cell H1 to fill with in the other days of the week.
-
-
3
Type "12:00 AM" in cell A2. Select A2 and grab the fill handle. Drag it down to cell A25 to fill each cell with an hour, giving you 24 hours on your calendar.
-
4
Select cells A2 through H25. Right-click and select "Format Cells." On the Alignment tab, select center for both vertical and horizontal. On the Border tab, select a thin or dotted line in the Line Style box, then select "Outline" and "Inside" in the Presets section. Click "OK" to apply these changes.
-
5
Select cells A1 through H1. Right-click and choose "Format Cells." On the Alignment tab, select center for both vertical and horizontal. On the Font tab, change the font if you want, and select a larger, legible size (16 through 20 work well). On the Border tab, select the thickest line in the Line Style box, then select "Outline" and "Inside" in the Presets section. On the Fill tab, select a fill color or pattern. Click "OK" to apply these changes.
-
6
Change the column width in cells A1 through H1 so that the text fits properly. Place your mouse on the line between the A and B column headers in the gray area just above the worksheet. When you see a thick line with arrows pointing right and left, double-click to adjust the column to the width of the text. Repeat with the remaining columns.
-
1
Tips & Warnings
If you need to type several lines of text into the calendar on any given time or day, select the cells, right-click and choose "Format Cells." Go to the Alignment tab and select the "Wrap Text" check box. The cell height will adjust to fit all the text.
