print a certain row as the header on each page

I would  like to print the same row on each page as the top row.  It is not 
the top row on the first page.
0
Michelle (113)
10/13/2005 8:25:05 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
374 Views

Similar Articles

[PageSpeed] 51

Michelle,

Go to File/Page Setup

Under Page Setup go the the Sheet tab

For the selection - Rows to repeat at top, go the cell reference and
select whatever row you want to repeat.

hope that helps.
Max


-- 
MAX258
------------------------------------------------------------------------
MAX258's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1538
View this thread: http://www.excelforum.com/showthread.php?threadid=476017

0
10/13/2005 9:14:00 PM
Reply:

Similar Artilces:

Row Re-numbering
Does anyone know if you are able to re-number the rows in Excel 2000? I am refering to the numbers generated by excel on the extreme left of the spreadsheet. Some how the numbering got out of sequence. Does anyone know how the rows get out of sequence? When I attempt to delete rows to test if the numbering changes, the rows renumber automatically. Based on my test, I'm not sure how the rows numbers got out of sequence in the first place. Thanks. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from...

after selecting grindlines, why does it still print without any?
After I select with grindlines , why does it still show none? go to the last tab in Page Setup dialog and select gridlines. Two different settings - one for the screen and one for printing. -- Regards, Tom Ogilvy "cson" <cson@discussions.microsoft.com> wrote in message news:BD89BC83-7D48-41A6-8309-D88DFA6943F6@microsoft.com... > After I select with grindlines , why does it still show none? Assuming you are selecting "gridlines" in the Page Setup>Sheet dialog. Perhaps you have "Draft Quality" checked also. Gord Dibben Excel MVP On Fri, 25 Ma...

How to do print and printpreview in non-view class?
In view class, we can do print and printpreview with OnPrint, OnPreparePrinting, etc. function. In non-view class, how to do? curiosity5374@yahoo.com.cn wrote: > In view class, we can do print and printpreview with OnPrint, > OnPreparePrinting, etc. function. In non-view class, how to do? Not sure about preview, but you can certainly do printing fairly easily. There's an article on the KB called "HOWTO: Print from a Class Other Than CView (Q133275)" that shows this. Paul. Try this article for printing without the Doc/View framework: http://www.codeproject.com/printi...

Outlook 2002 Calendar Printing Problem
When I try to print my calendar I get the following error message: "Unable to save the print settings. Make sure the file C:\Documents and Settings\bng\Application Data\Microsoft\Outlook\OutlPrnt exists and can be written to." How to I correct this problem? ...

IWebBrowser2:How to set HTML page content from a Stream contains <img> with src set to relative path rather than full image path
Hello, I try to use IWebBrowser2 to load html content from a stream, which contains image with "src" set to relative file path rather than full file path, it seems IWebBrowser2 can not resolve the image path even I put the executable and the image file under the same directory. The dynamic html content is simple as "<html><head><title>test</title></head><body><img src='test.jpg'></body></html>". Could you tell me how to do that? I use IHTMLDocument2::write to load html content dynamically. Thanks a lot. ...

Implementing a Label with certain data in Chart
Dear All ! I have a data set plotted in Excel. Is there any way to show automatically the minimum, maximum and median value of this data set on the chart? (In a form of label or anything similar) Minimum and maximum values are already part of data set. Median value is a calculated value and is in another cell(not part of data set). Thank You in advance I'd probably do this in a manner similar to what Jon Peltier shows here for the Vertical Category Axis. http://www.peltiertech.com/Excel/Charts/Y_CategoryAxis.html You could then create a custom format for each "Label" s...

modifying predefined page designs (or creating a variation of predefined page designs)
I have inserted a photo gallery using: INSERT / PAGE / PHOTOS / PHOTO GALLERY WITH LINKS. This generates a main gallery page with 12 images, each linked to a photo detail page. My problem is that I would like to modify the format of the photo detail pages--but preferably before inserting the photo gallery so I do not have to modify all 12 photo detail pages every time a gallery is added. I cannot find the photo detail page definition/template. Can it be modified? Can I create a modified version PHOTO GALLERY WITH LINKS based on the original? Any help would be greatly appreciated! Thanks...

Close header button
I am in a footer and the "Close Header and Footer" button is not illuminated and will not work. If you can't get the "Close Header and Footer" button to work, press the escape key and it will close the head and footer. "Miriam" wrote: > I am in a footer and the "Close Header and Footer" button is not illuminated > and will not work. If the "close header and footer" button does not work, press the escape key and it will close the header and footer. "Miriam" wrote: > I am in a footer and the "Cl...

Print address labels
Getting this message word cannot start converter mswrd632 or DOSWRD32 Click the Fixit button at http://support.microsoft.com/default.aspx?scid=kb;EN-US;973904 -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> "Robneedshelp" <Robneedshelp@discussions.microsoft.com> ...

Journal Entry List will not print
For Outlook 2002 - I'm not sure what I am doing wrong but each time I try to print or preview my journal view, I end up with this popup note "You cannot preview message headers until they are downloaded". I have tried searching knowledge base FAQs to no success. What does this message mean??? I can print or preview a single entry but not my custom view of entries. -- MLM Please supply the steps you're using to try to print. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers ...

Printing Old Publisher 98 File in Publisher 2002
A file from an Old Version of Publisher (98) won't print on the New Version of Publisher (2002) on my HP 6MP Laser Printer. How do I resolve this problem? Whilst attempting to develop brick-based storage technology, Ed reads a message from Ron Ward <Ronward@myibocs.com> > A file from an Old Version of Publisher (98) won't print > on the New Version of Publisher (2002) on my HP 6MP Laser > Printer. Have you worked through the print troubleshooter? How exactly is it not printing? Do other programs print? Do other Publisher documents print? Have you gone to the websi...

Lost Some Row Numbering
Somehow, when I cloned a worksheet to unused worksheet in my workbook, the numbering (in the left-most column) has lost the 1st 5 values (I failed to copy the 1st 5 rows). IOW, my worksheet starts with Row 6 and continues down from there. I can't find anything in Google that tells me how to fix this, so I'm asking here. Please advise. TIA hi, these lines are probably masked -- isabelle Le 2012-01-19 17:22, Mike Copeland a �crit : > Somehow, when I cloned a worksheet to unused worksheet in my > workbook, the numbering (in the left-most column) has lost the ...

Condtional Formatting
My conditional formatting applies to cells (see row numbers): =$B$41 =$B$42 When I insert 10 rows between row 41 and 42, the condition now applies to cells as follows: =$B$41:$B$51 1. Is there a way that the condtions will not be copied to rows 42 to 51? Or, the condition will apply only to each cell, i.e." =$B$41 =$B$42 =$B$43 etc. to =$B$51 Thank you. Use the absolute column reference of $B and the relative row reference of 41 to get the seconf optiont. =$B41 To not have the CF copied to the inserted rows, turn off the option to "exte...

bmp within header or footer
It seems I am not able to put a bmp of my company logo of the header or footer. If I want to have my logo on a spreadsheet, it can only be in the body of the spreadsheet, and looks goofy as it is "dangling" below the header area. Any tips/tricks??? Thanxs from SoCal Hi what Excel version are you using? -- Regards Frank Kabel Frankfurt, Germany "Justin" <jdignam@sbcglobal.net> schrieb im Newsbeitrag news:uZLgc3vhEHA.3200@TK2MSFTNGP10.phx.gbl... > > It seems I am not able to put a bmp of my company logo of the header or > footer. If I want to have my l...

How to roll down a new page
I have a welcome page that show for a instant and then is replaced with the home page. It would be nice if the Home page unrolled on top of the welcome page or slid in from the side like a slide might or the wecome page looked like a page turning. I have no idea how such things are accomplished. Can you give me a place to read up or a sugestion as to what to google? Thank Check out ASP .NET AJAX or Silverlight Develpment. -Scott " Cal Who" <CalWhoQQ@roadrunner.com> wrote in message news:umDEnSHdKHA.6096@TK2MSFTNGP02.phx.gbl... >I have a we...

Printing Question #2
I want to print sheets from several books, having the page numbers sequential (as tho they were all in the same book). Is this possible? It might be easiest to just create a new workbook, copy all the worksheets from each workbook into that new workbook. Then rearrange the worksheets in the order you want select all the worksheets File|page setup and fix the footer/header the way you want (if you want a common page number location) Then File|print|Entire Workbook (I'd check it with print preview first.) ====== If you have multiple workbooks open, you can use window|arrange|tiled ...

after each slide return to a certain slide
I have a game created in powerpoint, when asked the question and given the answer I need to return to the same slide where the questions are, what do I need to do this so when I click the mouse it returns to that slide? Thanks On 2/22/10 11:01 AM, Mary Sue wrote: > I have a game created in powerpoint, when asked the question and given the > answer I need to return to the same slide where the questions are, what do I > need to do this so when I click the mouse it returns to that slide? > > Thanks Here are a couple of things to try: (1) If they click on a butto...

Money 2003 Std. Printing reports
Using Money 2003 Standard Edition. I am trying to print a report. Having adjusted the width of the 'Payee' column so all is visable, I somehow managed to move the Date column also. The result is that the date now runs into the payee names without any space, making it very untidy to read. I tried clicking on the divider again between the Date and Payee colums but it seems locks, no matter which way I move it, the distance between the two columns remains the same. Microsoft seem to want everything to remain as you last used it, as when I try closing down and restarting, it presents its...

Row Limit in Excel
I work a lot with excel and I know that the row limit is 65,536, but I need more than that. Is there any way to make the number of rows infinite or at least to give me a certain amount of more rows. If there is please let me know. Thank you. -- Please help Molly, that is all there is, per sheet. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Molly" <molly_carols@yahoo.com> wrote in message news:FD2C7921-E249-4...

Receipt / Invoice printing Terms & Due date
Good day, We do a lot of charging on customer accounts. Is there a way to show the Terms and the Invoice due date on each invoice / receipt? Thanks in advance, Steve The only way I have been able to accomplish this is by putting the terms into a customer custom text field and printing that on the receipt. We then created a customization that will populate a receipt variable with the current date + the number of days in the terms. I have not been able to use any other receipt variable to get this to show up. Casey Hanson New West Technologies Check out amazing RMS extensions: http:...

Rows to columns
Hello all..............first post from an extremely newbie Excel user. My apologies if this particualr forum isnt the correct one for this post, however here goes :) OK, I've attached scren print of an excel spreadsheet (small extract of a larger one). On it there are columns A -> F. In column C there are 4 or 5 rows relating to one address. What i'm trying to do is move these rows into one single row, but move the number at the start of the address into the column in front. The ain is to be able to sort the entire work sheet into alphabetical order based on the street. Hopef...

Unable to delete rows/columns
Worksheets open with over 60,000 rows and many columns. Selecting cells and using the delete command does not work. Assume there is there is no links from worksheets to any other document because "Links" command is not highlighted. Charley Callahan Hi what does 'does not work' mean. Do you get an error? -- Regards Frank Kabel Frankfurt, Germany "charles Callahan" <ccallah2@tampabay.rr.com> schrieb im Newsbeitrag news:lYSLc.55646$IX4.7091715@twister.tampabay.rr.com... > Worksheets open with over 60,000 rows and many columns. Selecting cells and >...

Transport row`s data into separate etiquettes
hello, I wanted to make the data in the rows to be settled as etiquettes for later printing. I heard there was a way to transport them automatically. I would appreciate any answer, thanks. What are "etiquettes", tickets, labels? Perhaps the use of Microsoft Word, and Mail Merge and supply your Excel file as the data source. Agustin wrote: > hello, I wanted to make the data in the rows to be settled as etiquettes for > later printing. I heard there was a way to transport them automatically. I > would appreciate any answer, thanks. ...

Add row after column of duplicate info
I want to know if there is a way to have Excel automatically insert a blank row after a column if the number in the column changes. Example: Column B 110011 110011 110011 110345 110347 110347 Would like for it to automatically insert as below: 110011 110011 110011 Insert blank row here 110345 Insert blank row here 110347 110347 Insert blank row here Can anyone help with this? It would be greatly appreciated :) Debe Data|subtotals can add a line with subtotals between cells with common values. You can use the outline symbols to show just the subtotal line, select those visible rows ...

Printing doc to Document Image Writer then displays in image viewe
Greets all. I’m programmatically printing a Word Document to the Office Document Image Writter. After calling the wordDocument.PrintOut( ) method, the image of the document is then displayed inside of my default image viewer (which in this case, is IrfanView 4.2). Is there a way to suppress the “shelling out” and just process the document? Any help is appreciated! TIA. Environment: Office Document version: 2007 Visual Studio 2005 ...