ExcelBanter - How do I add "headings" in spreadsheet to update in a TOC?

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - How do I add "headings" in spreadsheet to update in a TOC? (https://www.excelbanter.com/setting-up-configuration-excel/43000-how-do-i-add-%22headings%22-spreadsheet-update-toc.html)

How do I add "headings" in spreadsheet to update in a TOC?

I have a spreadsheet that I am incorporating into a larger document as an
Appendix. How do I format the spreadsheet heading "Appendix A" so that it
will update on the Table of Contents?

All times are GMT +1. The time now is 08:45 PM.