| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting new row and pasting formulas from previous row
Hi,
I have a large spreadsheet, and I have been asked to add a new row and paste the formulas from the row directly above it. When I do this, the formula moves from say A1+B3 to A2+B4. How do I keep it A1+B3??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas without changing previous results/calculations | Excel Worksheet Functions | |||
| Pasting formulas | Excel Discussion (Misc queries) | |||
| keep previous formulas in tack | Excel Discussion (Misc queries) | |||
| Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
| Can I retain functions from a previous cell when inserting a new r | Excel Discussion (Misc queries) | |||
Threaded Mode
