Thread
:
Copy line multiple times throughout spreadsheet?
View Single Post
#
1
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett