Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drag and drop
I have a set of input data in (say) A2 to A4. Formula in A5 and A6 and input data in A7 to A9. Rows 5 and 6 is hidden. Row numbers and column headings are also hidden. The user types data into A2 and then drags to A9, in this process he overwrites that formula in rows 5 and 6. If I protect rows 5 and 6 then the standard excel error pops up. How can I drag the input values without overwriting the formula? -- Bonzo123 ------------------------------------------------------------------------ Bonzo123's Profile: http://www.excelforum.com/member.php...o&userid=24182 View this thread: http://www.excelforum.com/showthread...hreadid=378035 |
#2
|
|||
|
|||
The same will happen if you copy and paste. You'll need to paste into the two
areas instead in two goes or select the two areas by using the Ctrl key. Highlight the first area with the mouse, then press Ctrl key and highlight the next area keeping the Ctrl key pressed, then release the Ctrl key and Paste. -- Regards, Martin "Bonzo123" wrote: I have a set of input data in (say) A2 to A4. Formula in A5 and A6 and input data in A7 to A9. Rows 5 and 6 is hidden. Row numbers and column headings are also hidden. The user types data into A2 and then drags to A9, in this process he overwrites that formula in rows 5 and 6. If I protect rows 5 and 6 then the standard excel error pops up. How can I drag the input values without overwriting the formula? -- Bonzo123 ------------------------------------------------------------------------ Bonzo123's Profile: http://www.excelforum.com/member.php...o&userid=24182 View this thread: http://www.excelforum.com/showthread...hreadid=378035 |
#3
|
|||
|
|||
Thanks Martin regards brian -- Bonzo123 ------------------------------------------------------------------------ Bonzo123's Profile: http://www.excelforum.com/member.php...o&userid=24182 View this thread: http://www.excelforum.com/showthread...hreadid=378035 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell drop and drag | Excel Worksheet Functions | |||
Moving selected data | Excel Worksheet Functions | |||
Analyzing non numerical data in an excel spread sheet | Excel Worksheet Functions | |||
drag and drop to get a lot of wordarts? | Excel Discussion (Misc queries) | |||
drag and drop to get a lot of wordarts? | Excel Discussion (Misc queries) |