Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Can Pivot Table show headings beside the row labels ? | Excel Discussion (Misc queries) | |||
row headings on pages - proper formatting in page set up | Excel Discussion (Misc queries) | |||
Can I set column headings on every page and exlcude some pages? | Excel Discussion (Misc queries) | |||
How do I show hidden column and row headings in excel? | Excel Discussion (Misc queries) | |||
Excel 2003 Pivot tables - how to "show pages" | Excel Discussion (Misc queries) |