Create a calendar for the week, month, or entire year.
What to Know
This article explains four different ways on how to make a calendar in Excel.
In the search field, typecalendarand opt for magnifying glass to initiate the search.
tigerlily713/Pixabay
pick the calendar style that suites your needs.
This example uses theAny year calendar.
Once you’ve selected your calendar, selectCreate.
Each calendar template has unique features.
OpenExceland jot down the days of the week in the first row of the spreadsheet.
This row will form the foundation of your calendar.
This will be a grid of seven columns and five rows.
All seven columns will adjust to the same.
Next, adjust the row heights by selecting the five rows under your weekday row.
Adjust the height of the first column.
Next, you should probably align the day numbers to the upper-right of each daily box.
Highlight every cell across all seven columns and five rows.
Right select one of the cells and selectFormat Cells.
Under theText alignmentsection, setHorizontaltoRight (Indent), and setVerticaltoTop.
Now that the cell alignments are ready, it’s time to number the days.
Find a calendar example for January.
For 2020, for example, the first day of the month starts on a Wednesday.
For 2020, starting on Wednesday, number the dates in sequential order until you get to 31.
Now that you have January finished, it’s time to name and create the rest of the months.
Copy the January sheet to create the February sheet.
Right-tap the sheet name and selectRename.
Once again, right-hit the sheet and selectMove or Copy.
UnderBefore sheet, select(move to end).
SelectOKto create the new sheet.
Right poke the sheet, selectRename, and typeFebruary.
Repeat the above process for the remaining 10 months.
Now it’s time to adjust the date numbers for each month after the template month of January.
Do the same for the rest of the calendar year.
Remember to remove non-existent dates from the months that are not 31 days long.
Insert a top row by right-clicking the top row and selectingInsert.
throw in the month name into the single cell, and reformat the font size to16.
Repeat the process for the rest of the calendar year.
Once you’re finished numbering months, you will have an accurate calendar in Excel for the full year.
you’re able to print any month by selecting all of the calendar cells and selectingFile>Print.
SelectPage Setup, select theSheettab, and then enableGridlinesunder the Print section.
SelectOKand thenPrintto send your monthly calendar sheet to the printer.
you might create full a 24-hour calendar or limit it to a typical work schedule.
Open a blank Excel sheet and create the header row.
Leaving the first column blank, add the hour when you typically start your day to the first row.
Work your way across the header row adding hour until your day is complete.
Bold the whole row when you’re done.
Leaving the first row blank, pop in out the days of the week in the first column.
Bold the whole column when you’re done.
Highlight all rows that include the days of the week.
Highlight all columns that include the hours of each day.
To print your new daily agenda, highlight all cells of the agenda.
Change the orientation toLandscape.
SelectPage Setup, select theSheettab, and then enableGridlinesunder the Print section.
Change Scaling toFit All Columns on One Page.
This will fit the daily agenda to one page.
If your printer can support it, change the page size toTabloid (11" x 17").
This design concerns the date and month, rather than the day of the week.
Open a blank Excel sheet and, leaving the first column black, add January to the first row.
Work your way across the header row until you reach December.
Bold the whole row when you’re done.
Leaving the first row blank, throw in out the days of the month in the first column.
Bold the whole column when you’re done.
Highlight all rows that include the days of the month.
Highlight all columns that include the months of the year.
To print your new yearly agenda, highlight all cells of the agenda.
Change the orientation toLandscape.
SelectPage Setup, select theSheettab, and then enableGridlinesunder the Print section.
Change Scaling toFit All Columns on One Page.
This will fit the agenda into a single page.
FAQ
To insert a calendar in Excel using a template, open Excel and selectNew>Calendar.
Choose a calendar, preview it, and selectCreate.
SelectMicrosoft Date and Time Picker Control>OK.
This will put a drop-down calendar in the cell.
Tomake a graph in Excel, highlight the cells you want to graph, includingLabels,Values, andHeader.
Go toInsert>Chartsand choose the throw in of graph you want.
Graphs also have various styles.
For example, if you chooseBar Graph, you’ll have six to choose from.
SelectOKand the graph will appear in the cells you selected.
Tocreate a drop-down list in Excel, open two blank worksheets.
One will include the data for your drop-down list and the other will contain the drop-down.
slide in your data, and then enter the topic the list applies to in the drop-down list document.
