How to Create a Weekly 24 Hour Calendar With Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Make your own 24-hour weekly calendar using Excel's columns and rows or customize an Excel calendar template.

Make Your Own

Step 1: Create Time Label

Image Credit: Image Courtesy of Microsoft

Open a blank spreadsheet in Microsoft Excel and type Time in the A1 box.

Advertisement

Video of the Day

Step 2: Create Day of Week Labels

Image Credit: Image Courtesy of Microsoft

To create the days of the week labels, type Sunday in the B1 box and drag the box to H1, covering seven columns. The other days of the week automatically fill in these boxes.

Advertisement

Step 3: Assign Times

Image Credit: Image Courtesy of Microsoft

Type the time you want the daily calendar to start in the A2 box and drag the box to the A25 box. This automatically adds the rest of the hours for the day.

Advertisement

Step 4: Fill in Schedule

Image Credit: Image Courtesy of Microsoft

Type your schedule and appointments in the corresponding boxes.

Advertisement

Advertisement

Use a Scheduling Template From Microsoft Office

Image Credit: Image Courtesy of Microsoft

Open a new Excel document and search for a weekly calendar template.

Advertisement

Step 2: Choose Template

Image Credit: Image Courtesy of Microsoft

Select the template you want to use and click Create.

Advertisement

Step 3: Fill in Agenda

Image Credit: Image Courtesy of Microsoft

The templates in Excel are interactive. To fill in a Microsoft template, click the field you want to fill in and type your information.

Advertisement

Advertisement

Find a Template Online

Video of the Day

Step 1: Search For Templates

Image Credit: Image Courtesy of Microsoft

Go to the Microsoft Office website and search for templates.

Advertisement

Step 2: Select a Template

Image Credit: Image Courtesy of Microsoft

Search for the template you want to use and click the template's thumbnail picture.

Advertisement

Step 3: Open the Template

Image Credit: Image Courtesy of Microsoft

Click Open in Excel to open the template in an Excel document.

Advertisement

Advertisement

Step 4: Sign in to Excel

Image Credit: Image Courtesy of Microsoft

Sign in with your Microsoft account if you have one. You can also sign in with your work or school account. If you do not have an account, create a new account.

Step 5: Continue to Excel

Image Credit: Image Courtesy of Microsoft

Click Continue to create your template document.

Step 6: Use Excel Online

Image Credit: Image Courtesy of Microsoft

If you want to continue to use Excel Online, click the field you want to fill in and type your agenda. However, if you want to work in your Excel desktop application, click Open in Excel.

Step 7: Use Excel on Desktop

Image Credit: Image Courtesy of Microsoft

After you open your Excel desktop application, you can click the field you want to change and fill in your schedule.

Advertisement

Advertisement