Free Microsoft Excel 2013 Quick Reference

Print row and headings/labels on every page in Excel?

I pulled up the help screen and can see that there is a way to get the titles
to show on each page, but can't get it to open.

Also, want to make a new page, making my own page break like in Word - with
Control Enter. Not sure how to do this.

How do you get the help to access the help too.


I'm trying to print 1 row and 3 column headings on every page. When I try it
under file/page setup/sheets I select the row to repeat at top then columns
to repeat at left. When I try to print or preview I get the error message
"print titles must be contiguous and complete rows or columns." What can I do?

Hi,
How do I get Excel to not cut off the text in the 6th row when I want to
repeat 6 rows and 1 column on multiple pages for printing?

I'm trying to print a solid border on every page around a table done ion
excel. Currently, at the page break my border is being chopped until the
last page. How do I keep a solid border on my table on every page?

How do I make the contents of a cell on one page in excel equal to another
cell on another page in excel?

I have a spreadsheet in excel and want several rows and columns to print on
every page. It will display by freezing panes but I need it to print that
way also.

i want to repeat some columns and rows for titles and labels on every page of
my worksheet...........no problem with the column titles coz it appear on
every page....my problem is with the rows coz it DOESN'T appear on the
succeeding pages when I've already declared these rows as print titles on the
sheet tab in the page set-up.

help......

Hi you'll,

I have great printing macro that prints an area based on 1 cell.
Sub SetPrintRangeStudent1()
    Dim PrintRange As Range
    Dim FindRange As Range
'this line finds the location of the student in row 7
    Set FindRange = ActiveSheet.Rows(7).Cells.Find(Range("D1"), , xlValues, xlWhole, xlByRows, xlNext, False)
        If Not FindRange Is Nothing Then
'this line set the print range to 2 rows above the FindRange and 10 columns to the right
'it finds the bottom row automatically
Set PrintRange = Range(FindRange.Offset(-2, -3), Cells(65000, FindRange.Column).End(xlUp)).Resize(, 10)
ActiveSheet.PageSetup.PrintArea = PrintRange.Address
ActiveWindow.SelectedSheets.PrintPreview
    End If
End Sub
I like to adjust this, so that on every page it also prints C9:C20.
Do I set a second print range for this?

Every suggestion is helpful.

Marco.

I am copying and pasting a chart into excel from another application. The timeline(s) cover many pages. I can get the header to repeat by printing the first 6 lines on every page, but I am unable to print the (legend) on every page. It does not allow me to insert this information into the footer.

Dear Sir,

How to findout LastRow on every page in sheet.

http://www.vbaexpress.com/forum/showthread.php?t=13260

Actually I want to apply following border to lastrow of every sheet page

 With Selection.Borders(xlEdgeBottom)
        .LineStyle = xlContinuous
        .Weight = xlThin
        .ColorIndex = xlAutomatic
    End With
Please help

Hi,
I am new to excel vb, but have a question on how to 'loop' the same macro on every tab.
I have recorded the macro, but don't know how to edit it so that it executes on every page in the workbook.
I hope that someone can help - it would save a ton of time!
Thanks

Hi,

I have put headings on the first row (and frozen that row). Underneath the headings, are numbers which go on for many rows (about 3 pages). How do I print so that I can get the headings on every page?

Thx much!

I followed the instructions for getting a heading row to repeat on every
page, but I couldn't get it to work.

I have some reports that are between 30 and 40 pages long and I usually use
the page setup option to put column headings on every page, but some of the
pages do not need column headings and I cannot find a way to eliminate the
column headings on those few pages without manually copying headings on each
page I would like them to appear which is very time consuming. Please help
with any information to make this an easier process.

i want to know that can i print bottom row repeat in the bottom of every page
in the worksheet and if it is possible then suggest me

I'm trying to get the RowFields on my PivotTable to show on every page when my sheet is printed
The document is 2 pages wide and 1 page tall
What's the best way to do this?

Hello, I have used the formula that looks like this, "A1:J1" and it has
worked before, but now it isn't! I may have been using a different version of
Excel (at work). I have the Office XP product here, and I'm stumped.

Also, if I want to repeat two rows at the top of every page, how would I do
that?

File > Page Setup, click on the Sheet tab, then in the "Rows to Repeat at
Top' indicate which rows comprise your header (ex: $1:$1).

"Dave" wrote:

> How do I print a large spreadsheet where the column headers show up on every
> printed page?
>
>
> --
> Dave

Hello, I have used the formula that looks like this, "A1:J1" and it has
worked before, but now it isn't! I may have been using a different version of
Excel (at work). I have the Office XP product here, and I'm stumped.

Also, if I want to repeat two rows at the top of every page, how would I do
that?

Hello:
I created a spread sheet with Titles in Column A. I need to have those Titles print on ever page. I went to File / Page Setup / Sheet and found the "Columns to print at left" field. What do I need to enter to get the Titles to print out on every page. I entered A1:A32 but that did not work.

Yor help is greatly appreciated.

Thanks

artemisia

Hi all,

I have a spread sheet summary that when printed will probably be around 10pgs. How can I have my formatted header columns print and show on every page without putting new heading columns under each page break?

Thanks!

Is there a way to tag rows in Excel so that they stay together (same page)
when printing? I have sub heading rows in a spreadsheet that I would like to
make sure stay with the subsequent rows when I print it, instead of leaving
some one one page and the others on the next.

I have a list of information, each row may go to a different person once it is printed. The problem is each copy needs a title header. My solution currently is to use print title to appear at the top of each page and make the rows very tall so that only the title row and 1 other row of information show on each page.

To be a bit more environmentally conscious (and to avoid way too much empty space on each page) I'd like to print out multiple columns on each page but have the title header appear after each cell, any ideas how to make this happen?

Currently
Header
Information
---page break ---
Header
Information

Goal
Header
Information

Header
Information

Header
Information

Header
Information

Header
Information
---page break ---
Header
Information

Header
Information

Header
Information

Header
Information

Header
Information

Does anyone know how to repeat disjointed rows on every page of an Excel spreadsheet? For instance, printing rows 1-4 and 37-42 on every page.

Thanks in advance for any help :biggrin:

Hi,
I have a table of contents in a 2007 excel worksheet. I am going to convert that file into an pdf file. My question is: is there a way to make the heading in the first row ( it is frozen in place by freeze panes) appear on every page in the pdf? The list is about 400 rows long and works out to about 4 pages in the pdf. I want the heading row to be at the top of each seceeding page after page 1 of the table of contents. Can I do this besides manually insert the row at where it should be before printing to a pdf?
Thanks for your help.
Stuartray