I'm making a worksheet with multiple sections of calendarized expense

data by region. I want to add some formulas to the first region, then

paste the formulas into the other regions. Is it not possible to paste

only, formulas, without pasting the values from the first region as

well? When I try, it pastes the values in the reference cells also.

Thanks.

Troy

No, unfortunately this is not possible. The nearest I've found is this:

Immediately after pasting formulas and constants (that is, whilst all the

cells are still selected), use

Edit > Go To > Special > Constants

Then press the Delete key to clear the constants, leaving just the formulas.

1. My "paste special - formula" in Excel pasts values and formula?

2. Why is "Paste Link" dimmed when I go to Paste Special?

3. Where can I find the old "Paste Special" (Edit/Paste Special)?

4. Why is Paste Formulas option is acting like Paste All option?

5. Copy and paste formula; Value pastes instead

6. Macro to paste special value only VLOOKUP formulas

7. Paste special, formula bar does not show absolute values for lin.

8. visual basic command to special paste a row of formulas into value

9. Paste Special Value - Lost formula in Macro

10. Copy formula, paste special value add transpose into another formu

11. To copy and paste a formula or drag a formula now only pastes the.

12. Changing Of Values After A Copy And Paste Special: Why ?

13. Paste special, formulas crashing Excel when used with array formula

14. paste values without copy-paste values

15. I am unable to copy and paste and am unable to figure out why, wh.

2 post • Page:**1** of **1**