Free Microsoft Excel 2013 Quick Reference

How print header row at top of each page?

How do you get Excel 97 to print the header row at the top of each printed
page when the data is 300 or 400 rows long, for instance?

Jack


Post your answer or comment

comments powered by Disqus
In Excel XP on Windows XP, I need to freeze the first row (header row)
so that it will always appear at the top of every page and its data will
not be included in sorting. Only data below the first row should be
sorted. How do I do that? At present whenever I sort by any column, the
header row gets sorted along with the other data. That is unacceptable.

Lt. Ito

I'm printing out a spreadsheet, and I have set a row to appear on the top of each page by going to 'page setup'/'sheet'/'print titles'.

However, I want this to change for different pages.
Is it possible to choose a different header row for each page that is printed?

Thanks

Kestrel

I seem to remember being able to do this, but I can't say for certain and
can't remember for the life of me how.

If I have one row [the one I have on my sheet is not Row 1, but if it needs
to be I can make it Row 1], and I want that particular row to print on the
top of every page [as it has the column descriptions for my sheet].

Anyone know how to do that?

Any help would be great.

Thanks
Scott

This seems obvious, but I cannot get it to work. I am trying to print out a
doucument that has multiple pages, and I would like to have the header
information that is in Row 1 at the top of each printed page.
I have gone into Page Setup, and the tab called "SHEET", but it will not let
me enter any info in the "Print Titles" section.
Is there something that I need to do first in order to make these changes
enabled?
Thanks
Lance Gray

How can I make certain cells appear at the top of each page when excel an document is printed?

Please see attachment. I need the cells highlighted in green to appear at the top of each new page that is printed, with the other cells directly underneath.

The number of cells underneath fluctates over time as new tasks are manually added and deleted.

Hi folks.

Here's my issue:

I have a very long spreadsheet with about 5000 rows and about 20
columns. One row at the top of the document is devoted to "header"
information, in other words, what each column is, i.e., Name, Title,
etc.

I'm going to print out this document and would like to have that top
row repeat at the top of each page. It's not a true header (at least
not what I've been able to tell from the Excel Header & Footer screen),
so I'm stuck for a solution.

I'm using Excel 11.2 with a PowerBook G4 OS 10.4.4.

Thanks!

Stephen

Hi folks.

Here's my issue:

I have a very long spreadsheet with about 5000 rows and about 20
columns. One row at the top of the document is devoted to "header"
information, in other words, what each column is, i.e., Name, Title,
etc.

I'm going to print out this document and would like to have that top
row repeat at the top of each page. It's not a true header (at least
not what I've been able to tell from the Excel Header & Footer screen),
so I'm stuck for a solution.

I'm using Excel 11.2 with a PowerBook G4 OS 10.4.4.

Thanks!

Stephen

I would like to have the column labels appear at the top of each page
automatically. I am working with a spreadsheet in which I am either adding
rows, or wrapping text in a cell so that particular row gets wider, which
changes where the page breaks are. As a result, every time I work with the
spreadsheet, I have to manually move the column labels from their current
rows to the row at the top of the next page so that when I print the
spreadsheet, which is shared with others, we know what each column represents
on the several pages of the full spreadsheet.

Is this possible? I am using Excel 2003.

060622 Identify Row, at top of screen, presently showing.

Is there a way to identify the top of screen "LINE" that is currently
showing, as to your location in the spread sheet? thanks

If it matters, freeze pane lines, are in use.

I am looking to print the same header at the top of each printed page. I
have gone to File/Page Setup/Sheet. It then says rows to repeat at top
and I have put in the row number, it then says "reference not valid".
Is there a syntex problem or Am I totally wrong?

--
God's Kid
------------------------------------------------------------------------
God's Kid's Profile: http://www.excelforum.com/member.php...o&userid=28426
View this thread: http://www.excelforum.com/showthread...hreadid=481018

I am looking to print the same header at the top of each printed page. I have gone to File/Page Setup/Sheet. It then says rows to repeat at top and I have put in the row number, it then says "reference not valid". Is there a syntex problem or Am I totally wrong?

I want to repeat Row 3, Columns A-G at the top of each page when it prints.
How is that done?

I'm working on a spreadsheet with multiple sections, where I'd like to use
the "repeat rows at top" to designate a print title for all pages in the
first section, then designate a different row to repeat for all pages in the
second section.

(This is a function that Word supports for a multi-section document.)

I can do the same thing using multiple sheets in the same file, or by
manually inserting page breaks along with repeating the appropriate header
rows so that the correct header appears at the top of each page.

However, I'd prefer to have Excel do this automatically, if this feature is
available.
Thanks.

I would like my top row that has my 'labels' in the cells to print at the top
of each page that prints. Similar to the screen 'freeze pane' command except
on a printed copy. I know I could use the 'header' function, but that does
not allow me to format the cells the way that I want to. Any ideas? And if
I can do this for rows, does the same ability exist for columns?

Thanks for any help,
Learner101b

When I name the columns there's a way to make it a "header row" so it's
displayed on each page, but I can't remember how. Help?

Hi,

Anyone have any idea's on how to add a range of cells to the end of everypage that prints?

Something like in page setup you can add rows to repeat at the top...but I want rows at the bottom to repeat?

My range would be range("A359:I377") On every page that prints.

Thank You, Mike

I see in the Setup - Sheet's Tab you can select Row and column headings to be
printed, but that prints the litteral headings such as A, B, C and 1, 2, 3

I need for have the content that I have named my columns reprinted on the
top of each page so that users of my printed spreadsheet don't have to flip
back to page 1 see what the titile of a certain column is to understand the
data in a certain cell in page 3, etc. of the worksheet in printed format.

I'm familiar with the freeze pane issue so you can see the title cells when
scrolling the worksheet - that's not my issue - I need the top row to PRINT
on all pages of a mulitple page worksheet.

I am hoping someone can tell me how to print my header rows (1 & 2) on each page of a spreadsheet without having to reformat the entire sheet by copy/paste the rows.

The first row of my worksheet is a label row and I would like
for it to print at the top of every page when I print my
worksheet.

I have tried formatting the File/PageSetup/Sheet, using
$a1:$k1, however, I can't seem to get the right code.

Help is always appreciated. Thanks.

Is it possible to repeat rows at bottom of the page in the print out like rows to repeat at top..

I'm trying to select a row to repeat at top of page but that option is grayed
out in page setup. It is usually available. I'm using Excel in Office 2003.

I would like to be able to select, for example, rows 1-8 and rows 12-13 to
repeat on the top of each page of my spreadsheet.

I am using Office 2003

This article gives illustrated steps on how to display totals on top of a stacked column chart in Excel
http://vbacentral.blogspot.com/2009/...n-stacked.html

Is it possible to repeat rows on top of every page but one? Specifically, I have a seven page spreadsheet and I don't want the rows to repeat on the seventh page.


No luck finding an answer? You could always try Google.