how do i set up repeating row/column titles in Excel?

G

Guest

i want row and column titles to automatically fill into place in a working
spreadsheet, but i do not know how.

can someone tell me how to do this?
 
G

Guest

I'm not sure whether you want col/row titles to be on every page when
printing or to always be visible when viewing the worksheet.

For printing:
<file><page setup><sheet tab>
Set: rows and columns to repeat

For viewing:
Select the 1st cell below the col titles and to the right of the row titles
<window><freeze panes>

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
G

Guest

thank, ron, for helping me out with this. i managed to print out my document
exactly as i wanted it!

best,
antonio
 

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

import the data to match the column titles in Excel 1
Always view column titles 3
Column Titles 3
Consistent Sheet column header rows 2
How to print row in excel on one page 1
hiding row/column titles 1
In Excel, how do I change the titles of the cells from A,B,C etc? 10
Change font for row and column titles 6

Top