Keeping the Same Cell References

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

What's the easiest way of copying a cell with a formula in it and
pasting it into another cell with the exact same formula?

I also have ASAP utlities, and I couldn't figure out how to do it with
that either.
 
One way:

Remove the = sign before copying and re-insert it in the new location after pasting

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| What's the easiest way of copying a cell with a formula in it and
| pasting it into another cell with the exact same formula?
|
| I also have ASAP utlities, and I couldn't figure out how to do it with
| that either.
|
 
Manually.............just preface the formula with an apostrohe.

Copy and paste then remove the apostrophe from both spots.

For another manual method of copying multiple formula cells see John
Walkenbach's site.

http://www.j-walk.com/ss/excel/usertips/tip066.htm

By VBA macro for a single cell.

Sub CopyFormula()
Dim X As New DataObject
Dim CelCopyTo As Range
X.SetText ActiveCell.Formula
X.PutInClipboard
On Error GoTo endit
Set CelCopyTo = Application.InputBox( _
prompt:="Select the CELL" _
& "to which you wish to paste", _
Title:="Copy Cell Formula", Type:=8).Cells(1, 1)
X.GetFromClipboard
CelCopyTo.Formula = X.GetText
endit:
End Sub



Gord Dibben MS Excel MVP
 
Highlight the formula in the formula bar.

Either right click>Copy or Edit>Copy. Hit escape.

Then paste the formula wherever you want.

Of course, this doesn't help if you want to copy a whole block of formulas.
 
Yes, that's easier!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Highlight the formula in the formula bar.
|
| Either right click>Copy or Edit>Copy. Hit escape.
|
| Then paste the formula wherever you want.
|
| Of course, this doesn't help if you want to copy a whole block of formulas.
|
| --
| Biff
| Microsoft Excel MVP
|
|
| | > What's the easiest way of copying a cell with a formula in it and
| > pasting it into another cell with the exact same formula?
| >
| > I also have ASAP utlities, and I couldn't figure out how to do it with
| > that either.
| >
|
|
 
If you have downloaded the asap exe file, click on it (best when excel is
not open), and follow the instructions. There are step by step instructions
on the site.
http://www.asap-utilities.com/installation-step-by-step.php
You will have a new menu item in excel, called ASAP utilities. In this are
many things which are not available, at least with a couple of clicks, in
excel normally.
I use the convert numbers to text, creating an index sheet, and several
others regularly.
In the ASAP utilities in your excel menu is a link to the user guide (in pdf
format).
Hope that helps,
Barbara
 
After placing the cell in edit mode (F2, etc.), you can highlight the
formula in the cell or in the formula bar, copy, press escape and paste
where you want. Excel will not alter the relative addresses.
 
Thanks everyone for all the good ideas!

After placing the cell in edit mode (F2, etc.), you can highlight the
formula in the cell or in the formula bar, copy, press escape and paste
where you want. Excel will not alter the relative addresses.
Click to expand...
 
Back
Top