Headers and footers are essential for adding extra information to your spreadsheets, like page numbers, dates, or titles. In MobiSheets, you can easily add and customize headers and footers to keep your Spreadsheets organized and professional-looking.
After you enter your header/footer in the Page Setup window, you will be able to modify them.
Note: You can position your header/footer and customization in the left, right, or center part of the document (left, right, or center section).
How to add header/footer:
1. Open your Spreadsheet and click on Insert.
2. Click on Header & Footer.
Header and Footer position:
- Scale with Spreadsheet - select the box to scale header/footer according to the Spreadsheet.
- Align with page margins - select the box to align header/footer by the Spreadsheet’s margins.
- Odd and even pages - select to insert different header/footer for each odd and even page.
- Different first page - select if you want your header/footer on the first page to differ from the rest of the pages. Enter header/footer for the first page and header/footer for the rest of the pages.
Text formatting:
1. Select header/footer.
2. Click on the Font icon.
3. Modify the text.
4. Click OK.
Numerating pages:
Page number
1. Click on the right, left, or center section, depending on where you want additions to appear.
2. Select Page Number - MobiSheets will automatically display the consequent page number.
3. Click OK.
Total number of pages:
1. Click on the right, left, or center section, depending on where you want additions to appear.
2. Select Total number of pages - MobiSheets will automatically display the total number of pages.
3. Click OK.
Adding Time and Date:
1. On a Page Setup window, click in the left, right, or center section, depending on where you want time and/or date to appear.
2. Click on the time and/or date icons.
3. Click OK.
Note: Keep in mind that MobiSheets will display the time/date of printing to your header and footer.
Inserting File path, File name, and Sheet name:
1. On a Page Setup window, click in the left, right, or center section, depending on where you want additions to appear.
2. Select one or more icons, depending on the info you would like to add to header/footer.
- File path adds the file location to the header or footer.
- File name adds the file name to the header or footer.
- Sheet name adds the sheet name to the header or footer.
3. Click OK.
We hope this article has helped you understand how to add and customize headers and footers in MobiSheets.