1. On the “Customers” worksheet, click theSelect AllbuttonORpress Ctrl+A.

2. Click the arrow next toConditional Formattingfrom theHometab in theStylesgroup, then selectNew Rule.

3. ClickSelect a Rule Typein theNew Formatting Ruledialog box, then selectUse a formula to determine which cells to format.

4. In theFormat values where this formula is truebox, enter =MOD(ROW(),2)=0.

5. Click onFormat.

6. Click theFilltab from theFormat Cellsdialog box.

7. Select the desired shade background and then clickOK, you are able to view how the background would look in thePreviewwindow in theNew Formatting Ruledialog box.

8. Once satisfied, apply the formatting to the cells by clickingOK.

References:

https://support.office.com/en-us/article/Apply-shading-to-alternate-rows-in-a-worksheet-A443B0F5-2025-42F6-9099-5DE09C05E880

1. On the “Summer Bookings” worksheet, clickHeader & Footerfrom theTextgroup situation on theInserttab.

2. ClickClick to add footerwhich would display theHeader & Footertools which gets added to theDesigntab.

3. Specify where the page number should be by selecting theCenter sectionbox.

4. On theDesigntab in theHeader & Footer Elementsgroup, clickPage Number.

5. The placeholder&[Page]will appear in the selected section, to add the total numberofpages type the word of followed by the space in theHeader & Footer Elementsgroup after clickingNumber of Pages, then the placeholder&[Page] of &[Pages]appear.

6. Click anywhere outside the header or footer area to display the page numbers inPage Layout View.

7. Once you are done working in thePage Layout View, clickNormalin theWorkbook Viewsgroup situated on theViewtab. OR You can also clickNormalon the status bar.

References:

https://support.office.com/en-us/article/Insert-page-numbers-on-worksheets-27A88FB9-F54E-4AC4-84D7-BF957C6CE29C