Following is the procedure to expand the job report to show more than 40 candidates:
1. Right-Click tab name and unprotect the Job Report tab using password indzara
2. Select Column A and C -> Right-click and unhide column B
3. Select formulas in the last row (A50:J50) and select & drag the bottom right dot for additional rows : (A50:J58 selected in below example)
4. Select the newly added rows and change the row height as shown below:
5. Hide column B.
6. Protect the JobReport to ensure the formulas in it are not deleted accidentally.