How do I print the 1st column as a row header in each page?

[Guest]

This is a simple question that I could not format correctly in order to get
an answer from the Help file. Duh...would someone please point me to the
proper Help topic? Thank-you!

 

[Guest]

Found it! File/Page Setup/Sheet/columns to repeat on left...Thanks!

 

[Bernard Liengme]

Do you want to print the first ROW at the top of each page?
File | PageSetUp ; open Sheet tab and set Rows to Repeat on Top
best wishes

 

[Bernard Liengme]

Read that! set Columns to Repeat
best wishes

 

[Gord Dibben]

But that won't give you a row header on each page.

It will give you columns down the left side of printout.


Gord Dibben MS Excel MVP

 

[SteveW]

No wonder Help could give the answer

First rule - compose the right question.

anyway I think you've got the right menu options to give you control over
the page layout.

Steve

 

[Epinn]

I am not the original poster. But I am totally lost reading this thread. I
hope you don't mind me not starting a new thread.

I read Help and I experimented by ticking the checkbox for "rows to repeat
at top" and "columns to repeat at left" respectively. Then I clicked print
preview. But I didn't see any difference between ticking and not ticking
the boxes.

However, I did see a difference by ticking the "Row and column headings"
check box.

When I read the question, first thing that came to my mind was "transpose."

Can someone explain, preferably with a print layout on screen, about
rows/columns to repeat checkboxes, since I didn't get far with Help and
print preview?

Thanks.

Epinn

 

[Dave Peterson]

Start a new worksheet
put
=cell("address",a1)
in A1
Drag down 100 rows
select a1:a100 and drag across 50 columns

Now try those settings.

You should see a difference.

 

[SteveW]

"Rows and columns to repeat" are the contents of the specified cells
"Row and Column Headings" are A B C and 1 2 3 etc

You need to set the ones to repeat in File, Page Setup - not possible in
the preview
A,B 1, 2 etc are useful to help *document* a sheet especially when
printing the formula

Steve

 

[Epinn]

Dave,

Thank you. I did have a feeling that my worksheet wasn't set up properly to
do the test although I had more than one page.

Shall I say this is similar to freezing panes but more flexible? For
example, if I pick column B, only column B will be repeated. But for
freezing panes, both column A **and** B will be displayed, it just can't
drop A and display B alone.

I have my query solved plus I get a bonus i.e. learning about "address" in
Cell().

So Steve, it is okay that Lighthouse1 didn't compose the question right the
first time. Sometimes things happen for a reason and I got to learn
something. Yes, I am aware that we can only do the page set up under file
and not under print review for this particular feature.

Epinn