| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copy and paste
is there a simple way to copy an exact formula from one cell to past on
another. for example in Cell E1 i have =SUM(A1:A10) , if I copy and paste in to Cell F1 i get =SUM(B1:B10) I understand if i lock the cells using $ sign or name the range it will have the desired effect howvere I have about 200 or so to copy and paste (then slightly modify the forluma ) Any help much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy the formatted value and paste as a new value(not the original value with formatting)? | Excel Discussion (Misc queries) | |||
| In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
| copy paste cell character limit | Excel Discussion (Misc queries) | |||
| Copy and Paste | Excel Discussion (Misc queries) | |||
| How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) | |||
Threaded Mode
