If you want to apply the footer to all sheets in the workbook, right-click any of the worksheet tabs, then click Select All Sheets from the menu. To select more than one (but not all) worksheets, hold Ctrl (PC) or ⌘ Command (Mac) as you click each tab.
Enter the text you want to appear in any (or all) of the boxes. You can click the A button to adjust the font size, face, and style. To add page numbers, click the desired box, then click the second button (sheet of paper with a “#”). For the total page count, click the third button (multiple sheets with one “#”). To add the date and/or time, click the desired spot, then click the calendar (for date) and/or the clock (for time). To add the file name, click the yellow folder button (for the full path), the spreadsheet with a green and white “X” (the file name), or the spreadsheet with two tabs at the bottom (the worksheet name). To add an image, click the image button (the second-to-last one), and then follow the on-screen instructions to find and select an image. Click the paint can button at end of the row to edit the image. Click OK when you’re finished to return to the Page Setup window.
You can edit the footer at any time by clicking the Header & Footer button on the Insert tab at the top of Excel.
You can edit the footer at any time by clicking the Header & Footer button on the Insert tab at the top of Excel.
Check “Different odd and even pages” to create a second footer for alternating pages, and/or “Different first page” to have a different footer on the first page. Click the Custom Footer button. You’ll see that there are tabs for each of the footers you selected (Odd, Even, and/or First Page). Click the tab you want to edit, and then create your footer using the tips in step 6. Repeat this process for all custom pages. Click OK to return to the Page Setup window.
