Copy line multiple times throughout spreadsheet?

G

Guest

I know this is probably one of the most basic functions, but I can't seem to
find an easy way to do it without having to manually do it myself. I have
created a basic worksheet for my users to track referrals. several column
headings such as date, customer name, referral comments, etc. with each new
row as a new referral. What I am trying to do is have it so that my column
headings repeat say every 5 or 10 rows, so that no matter how far down in the
sheet a user is, they can always see those column headings to be sure their
data gets into the correct column. is there an easy, automated way to do
this or am i stuck with copy / paste, copy / paste?

Thanks in advance folks!
 
D

Don Guillett

Place your cusror just below the header desired>window>freeze panes.
Hopefully this is close to the top of the sheet
 

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

Access Access - Is it possible to repeat fields in a form? 1
Filter Sort Columns in a table. 3
Insert new row automatically 1
copying a large spreadsheet into Word 1
change array to simple columns 7
changing a range of cells throughout a 5 page spreadsheet 1
Scatter plot / Data from matrices? 1
Copying data from multiple file into one file 4

Top