Remember, you’ll have to repeat those steps every time you want to make a new schedule.

Add in your employees’ names and build your schedule.

Go to “Insert” and “Picture.” It’s a quick step that’ll add some customization. Customize your template - highlight cells and change the background colors to match your business’s branding.Double-click on the template and a new spreadsheet with this template will open.Scroll down and you’ll see a template called “Weekly employee shift schedule.”.In the search box in the upper right corner of the “Template Gallery,” search for “schedule.”.Go to “File” and then “New From Template.”.Here’s how to create an employee shift schedule in Excel: It’ll make your schedule look more professional and only takes a few minutes.Ĭreating an employee shift schedule with Excel Customize your color scheme and, if you’d like, add your logo.Google’s template includes a monthly overview as well as weekly schedules.

On the next page, the template gallery, choose “Employee shift schedule.”.

Click “New,” hover over the arrow next to “Google Sheets,” and choose “From a template.”.

Creating an employee shift schedule with Google Sheetsįirst, to create an employee shift schedule in Google Sheets : But if you still prefer creating your schedules with old-school spreadsheets, here are the best ways to do it with templates. Using modern scheduling software is the easiest and quickest way to schedule employee shifts. How to use a shift schedule template in Google Sheets or Excel

Monthly work rota template