in my workbook, i was trying insert a page number in the footer. However, after doing:
- select Insert
- Select Headers and Footer
- Some sheets have the Footer Tab and others don’t…HOW do I get the tab to come back
Some sheets have the Footer Tab and
others don’t…
Because they have different page styles. You must set the footer in all applied page styles, or you can use only one page style for all of the sheets.
In an Answer @LOmws had written this comment: (Answer deleted)
I am brand new to this product and the page styles look the same to me. I can’t see any difference, so is there a way to copy the style from one sheet to another? I have a 12 month spreadsheet with 7 not showing the footer tab and they are not all in a row. For example, May has no Footer Tab, June has the Tab and the rest of the it’s missing. This sheet originated in MS Office 2010 professional plus if that makes a difference.
“I can’t see any difference,”
Maybe all of the properties are same, but the name of the styles are different.
Please upload your ODF type sample file here.
“so is there a way to copy the style from one sheet to another?”
Just apply same style for the sheets by double clicking on the name of the desired Page style on the: Sidebar - Styles and formatting - Page Styles