#1
|
|||
|
|||
Multiple Headers in Same Worksheet
I understand fully how to create different headers in the same Word document... and I want to achieve that same effect in Excel (I'm using Excel 2007).
In other words, I have No Header on 1st page (did that successfully, simple enough), followed by 9 pages or with a lovely header... Now I need the next several pages to be identical, except for one variable. And I'll need to repeat that several times throughout the same worksheet. Is there a way I can do that? Thanks Last edited by Tom; 04-18-2009 at 01:06 PM. Reason: Growing distress |
#3
|
|||
|
|||
Thank you, zyzzyva57, for replying.
Ok, as usual, I see that the question I posed was about as clear as mud. Anyway, no, the videos you directed me to were helpful, but not what I wanted. 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: How to Create Dynamic Headers in Excel Here's the end result you want: You want a cover page, and there are three sections of this document once printed. You will also want page numbers, and different names to each of the different sections -- you can think of it like chapter titles. Oh, also, you will want row headers repeated not only on the printed page, but as you are working on the PC as well. This will make it easy to keep track of what column you are in since the column headers will always be visible. Same for the reader: once printed, this document will be easy to read because column headers are repeated on every page. The key thing to understand is that each section of the document will be on a separate worksheet within the same Excel document. So, let's say you already have content on a worksheet. On this worksheet, you already have your document's title page, and you have the first several pages of content. Let's start by changing Sheet1 to Inventory Status. Then...
Section 1: Reporting System Current Inventory: Inventory Status Section 2: Reporting System Current Inventory: Outdated Inventory Section 3: Reporting System Current Inventory: Damaged Inventory Good luck! |
#4
|
|||
|
|||
Multiple header rows in same Excel worksheet (not different tabs)
I have multiple header rows in the same Excel worksheet (not different tabs). And I would like to format the worksheet so that when I scroll down to the second header row, the words in heading 2 replace the words in heading 1 temporarily (until I scroll back up to the top of the page). Does anyone know how to do this?
|
Tags |
headers, multiple headers |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with headers | Bill | Word | 0 | 03-10-2009 05:15 AM |
Problem with headers Numeration... | omniteo790 | Word | 0 | 01-26-2009 03:57 AM |
TRANSFER DATA TO NEW WORKSHEET | BOBN | Excel | 0 | 11-08-2007 10:34 PM |
click a cell to go to a worksheet | victor | Excel | 0 | 10-27-2006 02:57 PM |
Include headers in table of contents | bwhight | Word | 1 | 10-10-2006 08:59 AM |