

there are three different parts of the reporting system you are documenting, hence the need for dynamic headers. In the Center section - and this is where we'll put the dynamic content - you'll type "Current Inventory" because this whole document is about the current inventory of your reporting system BUT. (I'm just making this stuff up, but I want to use actual sample content for this illustration.) You can manipulate your font size, color, style, etc., using the tool buttons. In the Left section, put your name of the document, "Reporting System".

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. 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.
