After adding the title, we will choose the next 5 cells varying from B9: J14 for filling the roster details of an employee. I have used the red font for dates and black for the days as well as Employee Name. Please note that the format is custom, and you can use it at your convenience. Employee Name would be the first one, and after that, each column from D to J contains one date and one day from the week starting from Monday. You can roughly say column headers for this roster. Step 4: From cells B7: J8, we are about to add some details for the shift roster therefore, create a box with Outside Border for the same range as we did in the previous step. Step 3: Create a box with Outside Borders (can be achieved with Ctrl+Shfit+& button) across cells B3: J5 and add some additional details there such as Minimum Shift Hours, Maximum Shift Hours, Overtime Hours, Overtime Rate, Night Shift Hours, Shift Allowance to capture the respective details. I have applied a red color font for the date values. You can customize the colors for this as per your requirements. Step 2: In cell A2, type “Week Start Date” and in the cell next to it (B2) type “.” This is the format in which the date will reflect for the start of the week. Step 1: In cell B1, input “Roster” as a title for the sheet and customize the formats for the same. There are thousands of these templates, and you can choose any one of your choices.įollow the steps below to create a free employee roster template of your own in excel from scratch.
Please note that you needed to be connected to a stable internet connection to be able to download the templates since we are downloading them as resources provided by Microsoft Office. Once you click Create, it will download that template for you and allow you to use it for your personal purposes.After that, click on the Create button, which appears on a window that pops-up as soon as you click on the template.Click on any one of the rosters templates.As soon as you click on New, you’ll see a search box where you can search thousands of Excel templates online just by giving a keyword as an input.Īll you need to do is type “roster” as a keyword, and thousands of online options will be available for you to download associated with a keyword.Open a new Excel file and navigate towards the File menu > New.Follow the steps below to use one of the thousands of free excel roster present in excel as a downloadable template.