How can I display a particular row on every page?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to view the heading row on every page in my Excel worksheet. How
can I do that? Thank you.
 
Hi

if its in the worksheet its self, click on A2 and choose window / freeze
panes
if you want the row to appear in the print out
choose file / page setup - sheet tab, rows to repeat at top and click on the
row number 1

hope this helps
Cheers
JulieD
 
If you're talking about printing the header row on each printed page........

File>Page Setup>Sheet>Rows to repeat at top.

Enter 1 or point to the row.

Otherwise, go with JulieD's freeze panes.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can i print (row) titles on all pages except the last page? 3
Formatting rows in a spread sheet. 8
I trying to develop a macro to print my worksheets 1
Blank Sheet with Gridlines 11
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Selecting every 4th row 3
Printing Frozen Cells Automatically on every page 2
How do I insert a page break between every row and column? 2

Back
Top