Make Agenda in Microsoft Excel  Step by Step Guide ▷ 2020

If you need to bring a control of your day to day, where you can organize all the activities pending to be doneAs well as the schedules of each one, it is best to make an agenda where you specify all the details of your days.

Inside the package Office, you can create a personalized agenda according to your needs. In this opportunity, we will teach you how to do it directly in Microsoft Excel.

Generally speaking, there are two ways to create an agenda. You can do it the way Handbook or through the templates that are already included within Excel, or that you can download on the Internet. Here we explain how to create an agenda in Excel quickly and easily!

Steps to create an agenda that allows you to organize your sessions in Excel

Keep your day to day organized, can help you optimize your work time and any other type of activities that you do day after day. With the help of Excel, you can create agendas and calendars to have everything under control.

Here’s how you can do it:

With a template

Template to create an agenda in Excel

The easiest and fastest way to do it is with the help of pre-designed templates and with which you only owe fill in the information. The use of them may vary a bit depending on your computer and the Office version with which you work.

In this sense, the steps to create an agenda in Excel with a template are:

  • Login to Excel.
  • Tap on “Archive” within the toolbar.
  • Click on “New” in the menu Archive. A menu of options next to the spreadsheet of the document.
  • Choose “My PC” in the options menu.
  • Go into “Template” and take a look at all templates available.
  • Choose template that you prefer.
  • Tap on “Okay” and fill in the information that you need.
  • Save and print in case you want it.

Other than that, keep in mind that if templates default of Excel they are not to your liking, you can download other models on the Internet.


Create an agenda manually in Excel

There is another way by which inexperienced users with design programs can create your personalized agendas according to your needs. It consists of doing it with the help of Excel. You may come across some limitations, but we will explain step by step how create an agenda manually with Excel No problem.

Then follow these steps:

  • Open a new spreadsheet in Excel.
  • Go to the tab Layout / Margins and click on Custom margins. When the box opens, enter the window pages and choose the orientation Horizontal.
  • Then in the same frame go to Margins and in the section “Center on page”, select both Horizontally and Vertically. Also in the margin measurements, writes “1 cm” In each one. In Header and footer, writes “0” (zero). Tap on “To accept”.
  • The sheet will be delimited with lines indicating the dimensions of the schedule.
  • In the spreadsheet, select columns A, B and C, press right click and “Width of the columns” writes “4 cm” and click OK. Do the same with columns E, F and G. In the case of column D, don’t alter anything yet.
  • Choose the first and second cells of each column Y customize it with the color you want entering the tab Start and, later, clicking on the paint pot.
  • Select the first cells of each column, right click and change the height in the option Row height. Write the value “1 cm”.
  • In the first cell of each column, write the different days of the week. In the case of Sunday, you must do it in the row G, cell number 19 and 20.
  • Select the other rows and change the height of them back to a value of “0.5 cm”.
  • To start design the boxes where the tasks are written, you have to select in each row the number of cells that you consider necessary to write the activities. For example: (A3: A8).
  • Once selected, go to the section “Format” Excel, in the option “Cells” and choose the filling in the section “Fill” in case you want it that way. You can also simply change the colors on the Home tab.
  • Do the same procedure in each section, that is (A9: A14 and A15: A20). When you already have an entire row layout, you can copy and paste in the others to apply the same Format.
  • In the case of the last row, ie row G, you must select three cells above “Sunday”, right click, press Insert and choose the option of “Shift cells down”. This way, the Sunday sign will go down a bit.
  • After copy the layout of the other rows from cell 2 to 20 and paste it in row G. If you notice that there is a space left, simply right click on that cell and delete it.
  • Copy the layouts from cells 3 through 20 back Y stick them below the sign corresponding to Sunday. How you can see, cells in dotted box protrude in worksheet. The ideal to make everything fit, is to go deleting cells on Saturday and Sunday until they fit.
  • You will appreciate that the spaces for Saturday and Sunday they will be a little reduced compared to the other days, but the whole design goes back into the initial box. We recommend that for these days, put the same colors in cells with the aim of differentiating them from the rest of the week.
  • In each of the days, select the entire row and put outer borders on it.
  • Select all row D and go to Format, and in Cells choose the format you want for the whole row.
  • In the others cells that are left under the days of the week, you can place other pictures like “Notes” and else. Remember that everything depends on your needs.
  • One point to consider is that spreadsheet lines do not print. Only those in which place borders. However, if you want to get a better idea of ​​what it will look like, you can choose those cells and fill them with white color.
  • By last, copy all that format and paste it right after the guide lines to have two faces.
  • Print and ready.

Remember that throughout your design, you can customize fonts, size, colors, borders and much more according to your tastes. You can even Add images, boxes, etc.

List of the best templates to create personalized agendas in Microsoft Excel

Templates to create personalized agendas in Microsoft Excel

There are many kinds of agendas that you can use in your day to day to organize different activities that include your job, lifestyle, health, food and much more.

Therefore, we share a list with the best templates to create personalized agendas in Excel:

Weekly agenda

It is from simpler and more common agendas. With her you can organize all the tasks of the week day by day. Have gaps in every hour, to write appointments or meetings in every time.

Download Excel Weekly Agenda Template

Blank daily calendar

With this template, the day is divided into half-hour chunks. In this way, you can keep a record of tasks, appointments, calls and others that you have pending in a day.

Download Excel Daily Calendar Template

Idea organizer

Is a excellent alternative if you are going to start a new project and don’t want to overlook any detail. Through this template, you can set daily goals, add tasks, due dates, write notes, among others.

Download Excel Ideas Organizer Template

Training plan

Is a type of ideal agenda to record your meals, training routines, nutritional supplements, among others aspects related to monitoring your lifestyle.

Download Excel Training Plan Template

Payment journal

With the help of this template, you can divide your expenses into up to 10 different categories and they are separated as checks are cleared from the patron’s record.

Download Daily Payment Template Excel

Personal monthly budget

It is perfect for control the entry and exit of money that you have every month. It is a very complete template in which you will have a record of what you spend in relation to what you win.

Download Excel Personal Monthly Budget Template

Priority task list

It is very beneficial for prioritize your different daily tasks, arranged in order. It is very simple and is available in PDF for to print Y fill in by hand.

Download Excel Priority Task List Template

If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will also be of great help to more members of the community. Thank you! 😉

You may be interested:

Rate this post

Leave a Comment