How to Remove Headers and Footers from Workbooks Headers and footers in workbooks may contain identifying information. On the File menu, click Page Setup . When you are done, click OK . Note that each worksheet in a workbook contains its own header and footer, so you need to repeat this process on each worksheet. Workbooks may contain hyperlinks to other documents or Web pages on an intranet or the Internet.
Hyperlinks usually appear as blue underlined text strings.
You can manually delete a single hyperlink from a workbook by right-clicking the hyperlink, pointing to Hyperlink on the shortcut menu, and clicking Remove Hyperlink . If you want to delete all hyperlinks in a workbook, you can use a Visual Basic for Applications macro to do this. How to Remove Styles from Workbooks Workbooks in Microsoft Excel may include styles that contain metadata. You can remove these styles, or rename them. On the Format menu, click Style .