How to insert a header in excel 2007 how to#

In the Left section, put your name of the document, 'Reporting System'. You have three sections of the header that you can use: the Left section, Center section and Right section.Your focus will then be on the Header tab of the new Header window, but notice that you have the option of creating a First Page Header that will be different from the rest. (This will ensure your header and footer do not appear on your title page.) Select the Different First Page checkbox.The Page Setup window will appear, and you should be on the Header/Footer tab. Go to the Insert menu, and select Header & Footer.Press Ctrl+Home so that you are at the upper left most cell in the worksheet.Let's start by changing Sheet1 to Inventory Status. On this worksheet, you already have your document's title page, and you have the first several pages of content. So, let's say you already have content on a worksheet. The key thing to understand is that each section of the document will be on a separate worksheet within the same Excel document. Same for the reader: once printed, this document will be easy to read because column headers are repeated on every page. This will make it easy to keep track of what column you are in since the column headers will always be visible. Oh, also, you will want row headers repeated not only on the printed page, but as you are working on the PC as well. You will also want page numbers, and different names to each of the different sections - you can think of it like chapter titles.

Here's the end result you want: You want a cover page, and there are three sections of this document once printed.

How to insert a header in excel 2007 how to#

The good news is: I figured out how to do what I wanted! My question should have been Since I already know how to create headers in Excel, how can I get a portion of the header to be dynamic, changing as needed throughout the printed document? So here it is: Anyway, no, the videos you directed me to were helpful, but not what I wanted. Ok, as usual, I see that the question I posed was about as clear as mud.