#How to remove add footer in excel 2016 how to
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. In our example, scaling the image down to 60 will do. To adjust the size, you can either change the height and width of the image or scale it up or down. 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. If you want to delete the Header from worksheet, you can put the cursor at the place where the header/footer is inserted, and click Design > Header (or Footer) > none under Header & Footer Tools. Then, click the ‘Format Picture’ on the ‘Header & Footer Elements’ group on the Ribbon. 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. The Excel 2010 and later versions do not have built-in watermarks, therefore we need to learn how to add and delete a watermark using the Header & Footer tools. It is a very common practice to re-use spreadsheets for new purposes. How to Add and Delete a Watermark in Excel The watermark is an image used in the background of the worksheet labeled as copy, draft, confidential or a picture of the logo. But if that information is no longer correct, then you may need to know how to delete a header in Excel 2013. Double click on This Workbook in the Project Explorer. Code added to the Workbook BeforePrint Event will be executed by Excel VBA before you print a workbook. Information in the header of a spreadsheet can include things like page numbers, you name, or the name of a report. Below we will look at a program in Excel VBA that creates a footer before printing a workbook.