The template is designed to handle data for 50 employees by default. The Calendar sheet displays up to 50 employees. If you need for more than 50 employees, it is very easy to extend. Let’s say we want to extend to 55 employees.

 Unprotect the Calendar sheet with indzara as password.

Unprotect or unlock sheet using indzara as password
Unprotect or unlock sheet using indzara as password

 

Select rows 59 to 63. Right Click and choose ‘Copy’.

Select 5 rows and copy
Select 5 rows and copy

 

Right Click on row 59 (row label) and choose ‘Insert Copied Cells’

Insert the 5 rows of copied cells
Insert the 5 rows of copied cells

 

You should now see the employees extended to 55.

5 new rows will be added to calendar
5 new rows will be added to calendar