Insert page number in the center of the footer on the "Summer Bookings" worksheet using the format Page 1 of 7.

Question

Explanation

1. Select the "Summer Bookings" worksheet, click Header & Footer from the Text group situation on the Insert tab. 2. Click Add to Footer worksheet which would display the Header & Footer tools which gets added to the Design tab. 3. Select the center section on the footer and in the Header & Footer Elements group. 4. On the Design tab in the Header & Footer Elements group, click Page Number. 5. In the Header & Footer Elements group, click Number of Pages. The Number of pages type the word of followed by the space in the Header & Footer Elements group after clicking Number of Pages. then the placeholder &[Page] of &[Pages] appear. 6. Click anywhere in the worksheet to exit the Header & Footer tab and activate the Page Layout View. 7. Once you are done working in the Page Layout View, click Normal in the Workbook Views group situated on the View tab. OR You can also click Normal on the status bar.

No community discussion yet for this question.