How To Make a Custom Weekly Calendar in Excel

Jan 07, 2020 • edited Jan 11, 2020

How To Make a Custom Weekly Calendar in Excel

Another great way to stay organized is to break your schedule down to a weekly level hour-by-hour.

Excel is great for setting up such a weekly schedule. Creating a weekly calendar is very easy.

  1. Open a blank Excel sheet and create the header row by starting at the morning hour when you start your day in the first cell. Then work your way across the header row, keeping the first column blank, by every hour until you go to bed. Bold the whole row when you're done.

  2. Type out the days of the week in the left column, leaving the first row blank. Bold the whole column when you're done.

  3. Highlight all rows that include the days of the week. Once all are highlighted, resize one row to a size that will allow you to write in your daily agenda.

  4. Highlight all columns that include the hours of each day. Once all are highlighted, resize one column to a size that will allow you to write in your daily agenda.

  5. To print your new daily agenda, highlight all cells of the agenda. Click File > Print. Change orientation to Landscape. Select Page Setup, select the Sheet tab, and enable Gridlines under the Print section. Change Scaling to Fit All Columns on One Page. This will fit the daily agend to one page. If your printer can support it, change the page size to Tabloid (11” x 17”).

  6. Having a printed daily agenda is a great way to keep your day organized on an hourly basis.

#Tutorial#How To#Calendar

How To Make a Custom Yearly Calendar in Excel