The most common reason why the header and footer are not visible in Excel is that the worksheet is currently using Normal view. Excel does not display headers and footers in the Normal worksheet view.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results