Question

Add the Sheet Name header element to the left header section, and the text Viewed On_ followed by the Current Date header element to the right header section. Click cell A3 to deselect the header to view the results.

Answer 1

To add a Sheet Name and date in the headers of an Excel spreadsheet, use the header/footer elements in Page Layout view, type in custom text, and select the required elements like Sheet Name and Current Date.

Step-by-step explanation:

To add the Sheet Name to the left header section, one would need to access the header/footer options in the Page Layout view and then choose the Sheet Name option from the header/footer elements. For the right header, the text Viewed On_ followed by the Current Date can be manually typed and then followed by selecting the Current Date element from the header/footer elements.

After making these changes, one would click on cell A3 to view the worksheet normally, without the header/footer editing mode being active. This action would allow the user to see how the headers will appear when printed or viewed in normal mode.