In Excel I need to insert a clean form each use

  • Thread starter Thread starter Robin
  • Start date Start date
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.
 
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
Inserting Picture Into Protected Worksheet 1
Can I get excel to automatically fill color to all unlocked cells? 3
Auto fill formulae when inserting rows 9
'Cannot insert object' message when I try to put a button on a worksheet 7
Bypass unlocked cell on protected worksheet in Excel 2003? 8
Is there a way to insert images into unlocked cells 1
How to insert new worksheet based on # of rows in a data sourch 2

Back
Top