Our tutorial below will show you how to delete the information in your header completely so that you can print the file without that information, or so that you can add new information to the header. Adding information to a header makes a printed copy of the spreadsheet much easier to identify, but subsequent uses of that file for other purposes can mean that the information contained in the header is no longer accurate. Whether it is a report that you redo on a weekly or monthly basis, or a spreadsheet that was sent to you from another person, it can be a real time saver to simply edit some information instead of recreating the entire file from scratch.īut a spreadsheet can contain some information that is specific to a particular instance of a file, and that information is often contained within the header of the file. Select Remove Footer from the popup menu. Then click on the Footer button in the Header & Footer group. I discovered in Excel 2007 that by converting this file into a table, I can automatically have 'banded rows', which I currently do manually. Make sure the Header/Footer tab is selected. If you want to get rid of the page header, follow these steps: Select Page Setup from the File menu. I created and maintain a basic inventory spreadsheet with a single header row, which I keep as a frozen pane. When you create a new Excel spreadsheet, it contains page headers. It is a very common practice to re-use spreadsheets for new purposes. Question: In Word 2007, how do I delete a footer in a document Answer: Select the Insert tab in the toolbar at the top of the screen. Our company recently upgraded from Excel 2003 to Excel 2007. But if that information is no longer correct, then you may need to know how to delete a header in Excel 2013. The Page Setup dialog window is minimized and you get back to the worksheet. Click the Collapse Dialog icon next to ' Rows to repeat at top' field. Find Rows to repeat at top in the Print titles section. You will see the Header and Footer dialog box, and the header area of the page.
In Print Layout view, you can simply double-click on the Header or Footer you want to delete.
If you are using Normal or Outline view, choose Header and Footer from the View menu. Make sure that you're on the Sheet tab of the Page Setup dialog box. Position the insertion point in the section that has the header you want to delete. Information in the header of a spreadsheet can include things like page numbers, you name, or the name of a report. Click on Print Titles in the Page Setup group.
0 kommentar(er)
