Drag and drop

  • Thread starter Thread starter Bonzo123
  • Start date Start date
B

Bonzo123

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?
 
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.
 

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

need held for auto date calculation for adding years and substract 1
Vlookup autofill for multiple worksheets 0
Alpha sorting (with a twist...?) 3
How to delete ALL cells containing the same data 1
if the numbers in sequence 11
How to use cell reference? 9
Help needed for inexperienced MS Excel 2003 user 2
average formula? 8

Back
Top