If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Show headings on all pages Excel 2003
Hi Everybody! Have a prob I thought I'd see posted here, but can't find it.
Am doing a spreadsheet for a friend---Has header rows and I'd like them to show on all pages so I don't have to copy/paste. I was able to do that quite easily, but feel like there is probably a setting I could hit to tell it to do it automatically. This is not a monumental deal....just curious. Thanks! |
#2
|
|||
|
|||
Show headings on all pages Excel 2003
Go to Page Setup
Select Sheet Tab In the Rows to repeat at top select the rows you want to repeat and you are set... "Bons" wrote: Hi Everybody! Have a prob I thought I'd see posted here, but can't find it. Am doing a spreadsheet for a friend---Has header rows and I'd like them to show on all pages so I don't have to copy/paste. I was able to do that quite easily, but feel like there is probably a setting I could hit to tell it to do it automatically. This is not a monumental deal....just curious. Thanks! |
#3
|
|||
|
|||
Show headings on all pages Excel 2003
If printing see Sheelo's reply.
If just want same titles on all sheets............... Select first sheet and right-click on sheet tab and "Select all sheets" Enter your row of titles on active sheet and will be done to all. When done, right-click and "ungroup sheets" Gord Dibben MS Excel MVP On Thu, 6 Nov 2008 10:25:03 -0800, Bons wrote: Hi Everybody! Have a prob I thought I'd see posted here, but can't find it. Am doing a spreadsheet for a friend---Has header rows and I'd like them to show on all pages so I don't have to copy/paste. I was able to do that quite easily, but feel like there is probably a setting I could hit to tell it to do it automatically. This is not a monumental deal....just curious. Thanks! |
#4
|
|||
|
|||
Show headings on all pages Excel 2003
THANKS to both of you!!! This is the BEST place to find answers to those
pesky little questions that can be so annoying. I tried Sheelo's suggestion and it did just what I wanted it to do. Then just out of curiosity I tried Gord's. I got the Select All Sheets---but could not find the "Ungroup Sheets". I'm not sure I would ever need this, but it's nice to have in the back of my mind, just in case. THANKS again to you for answering so quickly!!! "Gord Dibben" wrote: If printing see Sheelo's reply. If just want same titles on all sheets............... Select first sheet and right-click on sheet tab and "Select all sheets" Enter your row of titles on active sheet and will be done to all. When done, right-click and "ungroup sheets" Gord Dibben MS Excel MVP On Thu, 6 Nov 2008 10:25:03 -0800, Bons wrote: Hi Everybody! Have a prob I thought I'd see posted here, but can't find it. Am doing a spreadsheet for a friend---Has header rows and I'd like them to show on all pages so I don't have to copy/paste. I was able to do that quite easily, but feel like there is probably a setting I could hit to tell it to do it automatically. This is not a monumental deal....just curious. Thanks! |
Thread Tools | |
Display Modes | |
|
|