Wednesday, November 21, 2012

How to Create a Weekly 24 Hour Calendar With Excel


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.

Blogger news