Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel I need to insert a clean form each use
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel I need to insert a clean form each use
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 "Robin" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you insert lines in a quote form | Excel Discussion (Misc queries) | |||
How do i insert an interactive calendar in an excel form | Setting up and Configuration of Excel | |||
Clean Frame Around Excel | Excel Discussion (Misc queries) | |||
how do i clean out all non-letter characters from an excel sheet | Excel Worksheet Functions | |||
Excel Insert Function form | Excel Worksheet Functions |