In Excel I need to insert a clean form each use

R

Robin

I have created a protected worksheet with unlocked cells to be filled in by
the user and saved. Then next week I need to to have another copy of the
same blank form for the user to fill in with new data. I thought I could
just insert a copy of the form (as its own file) on Sheet 1, but can't figure
out how to do that.
 
M

Mike H

Robin,

Hold down the CTRL key, left click the sheet tab and drag to create a copy.
It will have a name of something like Sheet1 (2) so rename as required.

Mike
 

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

Insert pictures 5
Is there a way to insert images into unlocked cells 1
How do I insert picture in protected sheet 1
Signature in a protected document 0
How to insert new worksheet based on # of rows in a data sourch 2
'Cannot insert object' message when I try to put a button on a worksheet 7
How to protect some cells, but able to insert rows elsewhere? 6
Can I get excel to automatically fill color to all unlocked cells? 3

Top