Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Automatically copying fomulae when Inserting rows
I have a spreadsheet which has some complicated formulae in some cells, so I
want to lock and protect those cells to prevent other users from spoiling them. However, one of the things these users need to do is to insert rows to add new data in the correct place. I would like the formulae from the corresponding cells above the new row to be automatically copied. The only way to get the formulae in that I know is to use the "fill handle" but you cannot do that when the cell is locked. Is there another way? |
#2
|
|||
|
|||
Hi Ian,
If you and your users are all using Excel 2002 or later, you can protect the worksheet but still allow users to insert rows. Have a look at the options when you select protect worksheet from the menu. Hope this helps, Mark "Ian Goodhardt" wrote: I have a spreadsheet which has some complicated formulae in some cells, so I want to lock and protect those cells to prevent other users from spoiling them. However, one of the things these users need to do is to insert rows to add new data in the correct place. I would like the formulae from the corresponding cells above the new row to be automatically copied. The only way to get the formulae in that I know is to use the "fill handle" but you cannot do that when the cell is locked. Is there another way? |
#3
|
|||
|
|||
Hi Mark
Yes - I know you can allow them to insert rows, but how can you then copy the formulae from the protected cells in the row above (or below) the new row? I was hoping this could be done automatically. Ian "Mark Hone" wrote: Hi Ian, If you and your users are all using Excel 2002 or later, you can protect the worksheet but still allow users to insert rows. Have a look at the options when you select protect worksheet from the menu. Hope this helps, Mark "Ian Goodhardt" wrote: I have a spreadsheet which has some complicated formulae in some cells, so I want to lock and protect those cells to prevent other users from spoiling them. However, one of the things these users need to do is to insert rows to add new data in the correct place. I would like the formulae from the corresponding cells above the new row to be automatically copied. The only way to get the formulae in that I know is to use the "fill handle" but you cannot do that when the cell is locked. Is there another way? |
#4
|
|||
|
|||
?B?SWFuIEdvb2RoYXJkdA==?= wrote
Hi Mark Yes - I know you can allow them to insert rows, but how can you then copy the formulae from the protected cells in the row above (or below) the new row? I was hoping this could be done automatically. Ian "Mark Hone" wrote: Hi Ian, If you and your users are all using Excel 2002 or later, you can protect the worksheet but still allow users to insert rows. Have a look at the options when you select protect worksheet from the menu. Hope this helps, Mark "Ian Goodhardt" wrote: I have a spreadsheet which has some complicated formulae in some cells, so I want to lock and protect those cells to prevent other users from spoiling them. However, one of the things these users need to do is to insert rows to add new data in the correct place. I would like the formulae from the corresponding cells above the new row to be automatically copied. The only way to get the formulae in that I know is to use the "fill handle" but you cannot do that when the cell is locked. Is there another way? Have a look he (it ain't easy, but doable) http://www.mvps.org/dmcritchie/excel/insrtrow.htm -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting rows | Excel Discussion (Misc queries) | |||
inserting rows at common word in a sheet | Excel Discussion (Misc queries) | |||
Inserting rows | Excel Worksheet Functions | |||
Copying data without hidden rows. | Excel Worksheet Functions | |||
how i make a pgm in excel for copying all the rows to a new file . | Excel Discussion (Misc queries) |