assigning rows

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

Guest

How would I assign a row to appear at the top of every page? For instance, I
have data in row 1 and I would like it to appear at the top of every page as
a master of kinds.
 
To have the top row(s) remain visible while you're working, select the next
row and Window > Freeze Panes. To have the top row(s) print on every sheet,
goto File > Page Setup, select the Sheet tab and choose the rows in the entry
'Rows to repeat at top' (the entry will read something like $1:$1).
 
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

using the =page! feature to transpose a row to column 0
Print Column Heads WITHOUT Excel Column Lables 1
Printing a Different Row Heading Mid-way through a Spreadsheet 1
Selecting rows. 3
Excel Is this possible?? 3
Copy rows between different sheets if condition met 5
row heading to show on all pages 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top