When you hand off your worksheet to the facilities team, another colleague will add information about contractors working on site. To create a placeholder worksheet for this data
Please help me with these steps.
- Switch to the Scheduling worksheet. In cell A3, change the cell content to Week of February 22, 2021 (instead of Week of February 15, 2021).
- Cut the contents and formatting of the range D15:E18 and paste them into the range A13:B16.
- In cell B13, create a formula using the COUNT function to determine the number of projects that have booked facility hours by counting the values in the range C6:C11.
- Adjust the zoom level of the Scheduling worksheet to 120%.
- Change the page orientation of the Scheduling worksheet to Portrait.
- Some weeks you need to track facilities-related information, but that's not necessary this week. Move the Facilities worksheet between the Projects and Scheduling worksheets, then hide the Facilities worksheet.
- When you hand off your worksheet to the facilities team, another colleague will add information about contractors working on site. To create a placeholder worksheet for this data, insert a new worksheet in the workbook, rename the worksheet Contractors, and if necessary, move the new worksheet after the Scheduling worksheet.
davidmacago asked 2 years ago
For number 6:
Copy (right click and find copy option) the content "Week of February 22, 2021". Go to the excel worksheet. Click cell A3. Paste (right click and find paste option) it in the status bar as shown in video below to preserve the styles of a cell.
For number 7:
Select D15 cell. Hold
shiftkey and click E18 cell. Right click and find Cut option. Select A13 cell, holdshiftclick B16. Right click and find paste option.For number 8:
Click cell B13, type
=count(c6:c11)and hit enter.For number 9:
On the bottom of right-hand-side. There is slider to zoom-in or zoom-out.
For number 10:
Go to 'Page Layout' tab. Click on orientation and click Potrait.
For number 11:
Click Facilities which is in the bottom bar. Hold it and drag between Projects and Scheduling.
For number 12:
There is + sign in the bottom right side. Click there and it will automatically create new sheet with new name. Right click on its name and click rename option and type 'Contractors'
Here is the video explanation: