View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Copy line multiple times throughout spreadsheet?

I hope you're a girl.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MEE" wrote in message
...
I love you Don! :D lol j/k That will work great.

"Don Guillett" wrote:

Place your cusror just below the header desiredwindowfreeze panes.
Hopefully this is close to the top of the sheet

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MEE" wrote in message
...
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!