Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Worksheets, Copy and Paste Question
Hi,
I would appreciate any help you can give with my following question. I am trying to lock different sections within a worksheet, and I am wondering if there is a way to lock a worksheet but still allow a user to insert rows and copy and paste formulas into those newly inserted rows. Thank you again for your help. Philip |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Worksheets, Copy and Paste Question
When protecting a worksheet you can select various options including insert
rows and columns and select locked and unlocked cells. In order to paste into newly inserted rows these inserted rows must lie within the unlocked sections of the sheet i.e. unlock A1:D10 and protect the sheet but allow insert rows. Insert a row at A3.................you can copy/paste into that row in columns A:D only. Insert a row at A14...........you cannot copy/paste into that row. Gord Dibben MS Excel MVP On Tue, 9 Jun 2009 08:18:01 -0700, Philip wrote: Hi, I would appreciate any help you can give with my following question. I am trying to lock different sections within a worksheet, and I am wondering if there is a way to lock a worksheet but still allow a user to insert rows and copy and paste formulas into those newly inserted rows. Thank you again for your help. Philip |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Worksheets, Copy and Paste Question
Hi Gord,
Thank you for taking the time to reply, I really do appreciate it. I understand that we can lock a worksheet and insert rows, however do you know if it is possible to insert rows and copy and paste formulas from the above row into the newly inserted row? In other words, I have a worksheet that has multiple data entry fields (both manual and calculated through formuals)... If I insert a row in a locked worksheet, is it possible to transfer the formula from the surrounding rows into the new row? (sorry this is somewhat hard to explain, please let me know if you need further clarification) Thank you again, Philip "Gord Dibben" wrote: When protecting a worksheet you can select various options including insert rows and columns and select locked and unlocked cells. In order to paste into newly inserted rows these inserted rows must lie within the unlocked sections of the sheet i.e. unlock A1:D10 and protect the sheet but allow insert rows. Insert a row at A3.................you can copy/paste into that row in columns A:D only. Insert a row at A14...........you cannot copy/paste into that row. Gord Dibben MS Excel MVP On Tue, 9 Jun 2009 08:18:01 -0700, Philip wrote: Hi, I would appreciate any help you can give with my following question. I am trying to lock different sections within a worksheet, and I am wondering if there is a way to lock a worksheet but still allow a user to insert rows and copy and paste formulas into those newly inserted rows. Thank you again for your help. Philip |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Worksheets, Copy and Paste Question
See David McRitchie's site for a macro which inserts a row or rows and
copies the formulas from above. http://www.mvps.org/dmcritchie/excel/insrtrow.htm Gord On Tue, 9 Jun 2009 10:48:01 -0700, Philip wrote: Hi Gord, Thank you for taking the time to reply, I really do appreciate it. I understand that we can lock a worksheet and insert rows, however do you know if it is possible to insert rows and copy and paste formulas from the above row into the newly inserted row? In other words, I have a worksheet that has multiple data entry fields (both manual and calculated through formuals)... If I insert a row in a locked worksheet, is it possible to transfer the formula from the surrounding rows into the new row? (sorry this is somewhat hard to explain, please let me know if you need further clarification) Thank you again, Philip "Gord Dibben" wrote: When protecting a worksheet you can select various options including insert rows and columns and select locked and unlocked cells. In order to paste into newly inserted rows these inserted rows must lie within the unlocked sections of the sheet i.e. unlock A1:D10 and protect the sheet but allow insert rows. Insert a row at A3.................you can copy/paste into that row in columns A:D only. Insert a row at A14...........you cannot copy/paste into that row. Gord Dibben MS Excel MVP On Tue, 9 Jun 2009 08:18:01 -0700, Philip wrote: Hi, I would appreciate any help you can give with my following question. I am trying to lock different sections within a worksheet, and I am wondering if there is a way to lock a worksheet but still allow a user to insert rows and copy and paste formulas into those newly inserted rows. Thank you again for your help. Philip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Paste Question | Excel Discussion (Misc queries) | |||
Copy/Paste Question | Excel Discussion (Misc queries) | |||
copy/paste drop down boxes (forms) without locking cell link? | Excel Discussion (Misc queries) | |||
How do I copy/paste drop downs withough locking the cell link inpu | Charts and Charting in Excel | |||
Copy and Paste between 2 worksheets with VBA | Excel Worksheet Functions |