This wikiHow teaches you how to add “leg” segments to the bottom of a worksheet to print in Microsoft Excel. This segment can include a variety of information, including the date, page number, file name, and even a thumbnail image.
Step
Step 1. Open the worksheet in Excel
You can double-click the file name on your computer to open it.
Step 2. Click the worksheet to which you want to add a leg segment
You can view the worksheet by clicking the sheet tab at the bottom of the Excel window.
- If you want to add a foot segment to all sheets in the workbook, right-click any worksheet tab, then select “ Select All Sheets ” from the menu.
- To select more than one worksheet (but not all), hold down Ctrl (PC) or Command (Mac) while clicking each sheet tab you want.
Step 3. Click the Page Layout tab
This tab is at the top of the Excel window, on the left.
Step 4. Open the Page Setup dialog box
If you are using a Mac computer, click the icon labeled “ Page Setup ” in the icon bar at the top of the screen. If you are using a Windows computer, click the small square with the arrow at the bottom of the "Page Setup" pane.
Step 5. Click the Header/Footer tab
It's a tab at the top of the window.
Step 6. Select the foot segment design from the " Footer " menu
The options in this menu are default options that usually meet the needs of most users. If the available options don't match your needs (or you want to add custom information), move on to the next step.
Step 7. Click Custom Footer to create your own foot segment
If you chose a design from Excel's built-in options, you can skip this step. This option displays three blank boxes (left, center, bottom) that refer to the area at the bottom of each page. Follow these steps to add the information you need:
- Type the text you want to appear in any box (or all boxes). You can click the button " A ” to adjust the font size, appearance, and style.
- To add page numbers, click the desired box, then click the second button (a sheet of paper with " #"). To display the total number of pages, click the third button (multiple hard sheets with " #").
- To add a date and/or time, click the desired area, then click the calendar (for date) and/or clock (for time) icons.
- To add a file name, click the yellow folder button (full address of the file), the spreadsheet button with a green and white “X” (file name only), or the spreadsheet button with two tabs below it (sheet name only).
- To add an image, click the image button (second button from the end) and follow the on-screen instructions to find and select an image. Click the paint can icon at the end of the row to edit the image.
- Click " OK ” when finished to return to the “Page Setup” window.
Step 8. Click Print Preview to see what the leg segment looks like
The new segment will display as it appears on a printed copy of the worksheet.
Step 9. Click the back button to re-access the “Page Setup” page
If the leg segment doesn't look the way you want, you can choose another design or click “ Custom Footer… ” to edit your design.
You can edit the leg segments whenever needed by clicking the “ Headers & Footers " on tabs " Insert ” at the top of the Excel window.
Step 10. Edit the page number settings (optional)
If you want, you can display different foot segments on even and odd pages, and/or other segments on the first page. Follow these steps:
- Check the " Different odd and even pages " option to create a second leg segment for the next page (the pattern will be repeated alternately). You can also select " Different first page " to create different foot segments specifically for the first page of the document.
- Click the button " Custom Footer " You will see tabs for each selected leg segment (“ odds ”, “ Even ”, and/or “ First Page ”).
- Click the tab you want to edit, then design the leg segment using the tips in step six. Repeat this process for each specific page.
- Click " OK ” to return to the “Page Setup” window.
Step 11. Click OK
The foot segment has been added and will appear at the bottom of each printed sheet.
