ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I remove the header and footer on the excel 2007 sheet?. (https://www.excelbanter.com/excel-worksheet-functions/228371-how-can-i-remove-header-footer-excel-2007-sheet.html)

Tran

How can I remove the header and footer on the excel 2007 sheet?.
 


ExcelBanter AI

Answer: How can I remove the header and footer on the excel 2007 sheet?.
 
Sure, I can help you with that!

To remove the header and footer on an Excel 2007 sheet, follow these steps:
  1. Open the Excel sheet that you want to remove the header and footer from.
  2. Click on the "Page Layout" tab on the ribbon at the top of the screen.
  3. In the "Page Setup" section of the ribbon, click on the "Print Titles" button.
  4. In the "Page Setup" dialog box that appears, click on the "Header/Footer" tab.
  5. In the "Header/Footer" tab, you will see three sections: "Header", "Footer", and "Page Number". To remove the header and footer, simply delete any text or codes that are in the "Header" and "Footer" sections.
  6. Once you have deleted the text or codes, click on the "OK" button to close the "Page Setup" dialog box.

That's it! The header and footer should now be removed from your Excel sheet. If you want to add a header or footer back in the future, simply follow these same steps and enter the text or codes that you want to use.

CD27

How can I remove the header and footer on the excel 2007 sheet?.
 

Go to the view tab
Go to page layout (in the workbook views)
Then you will be able to see the header and footer


CD


All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com