creating a footer in Excel

Question

When I try to insert a footer in Excel, I get preloaded text options and I can't add a new footer. Headers are no problem, but I can't create a new footer.

Answer 1

Hi @Sylvia Simpson,

Thank you for posting your question in the Microsoft Q&A forum.

According to your concern, can you share a screenshot of the issue especially the "preloaded text options" footer that prevented you from adding new footer so I can clearly understand about the situation and provide the most appropriate guidance for your concern? In my test worksheet, when switching to Page layout view, I can easily click inside the Left, Center, Right footer box and type anything I want.

Please understand that my initial response may not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution. 

Thank you for your understanding and cooperation. I look forward to hearing from you 

Answer 2

To create a footer in Excel, you can use the Footer component in the Excel Report (ER) format configuration. If you're encountering issues with preloaded text options and unable to add a new footer, ensure that you are following these steps:

1. Access the Footer Component: In the ER format designer, locate the Footer component that you want to configure for your worksheet.
2. Add Nested Components: Under the added Footer component, you can add required nested components like Text/String, Text/DateTime, or others. Make sure to configure the bindings for these components to specify how your footer is filled in.
3. Use Different Footer Settings: You can add multiple Footer components for different pages (like first, even, or odd pages) of your worksheet. Ensure that each footer has a different value for the Header/footer appearance property to avoid validation errors.
4. Check Formatting Codes: You can also use special formatting codes to format the content of your footer correctly. Make sure you are familiar with these codes to customize your footer as needed.

If you are still facing difficulties, consider checking if there are any settings or restrictions within your Excel version that might be affecting your ability to add custom footers.