Click here to view our video tutorial.
Click here to download our PDF tutorial.
Welcome to Mark’s Excel Tips. Today, I will show you how to create a Weekly Timesheet Template, in Excel 365. Let’s get started.
To start, click on File.
![](https://marksexceltips.com/wp-content/uploads/2023/11/Slide2-1-1024x576.jpg)
On the right side of the home screen, click on more templates.
![](https://marksexceltips.com/wp-content/uploads/2023/11/Slide3-1-1024x576.jpg)
In the search box on the left, type in Weekly Timesheet. Hit enter, or click on the search icon.
![](https://marksexceltips.com/wp-content/uploads/2023/11/Slide4-1-1024x576.jpg)
Excel will load several templates for weekly timesheets. Let’s click on the first one.
![](https://marksexceltips.com/wp-content/uploads/2023/11/Slide5-1-1024x576.jpg)
In the window that opens, Excel tells you about this template and what it is best used for.
![](https://marksexceltips.com/wp-content/uploads/2023/11/Slide6-1-1024x576.jpg)
You can use the left and right arrows, to scroll through the different weekly timesheet templates. Each template will give you a brief description on what it can be used for.
![](https://marksexceltips.com/wp-content/uploads/2023/11/Slide7-1-1024x576.jpg)
When you find the template that you like, click on create.
![](https://marksexceltips.com/wp-content/uploads/2023/11/Slide8-1-1024x576.jpg)
Excel will load your Weekly Timesheet Template, ready for you to use.
![](https://marksexceltips.com/wp-content/uploads/2023/11/Slide9-1-1024x576.jpg)
Cell A 1 tells you that with this template, total hours and total pay are automatically calculated.
![](https://marksexceltips.com/wp-content/uploads/2023/11/Slide10-1-1024x576.jpg)
To add additional timesheets for other employees, simply click in the top left corner of the workbook and press Ctrl C, to copy the timesheet.
![](https://marksexceltips.com/wp-content/uploads/2023/11/Slide11-1-1024x576.jpg)
Next, click on the plus sign to add a new sheet.
![](https://marksexceltips.com/wp-content/uploads/2023/11/Slide12-1-1024x576.jpg)
Click in the top left corner of the new sheet and press Ctrl V to paste in the new timesheet.
![](https://marksexceltips.com/wp-content/uploads/2023/11/Slide13-1-1024x576.jpg)
View the Video Tutorial.
Download this tutorial in PDF by clicking the Download link below.