How to copy and past formula in another one sheet, without change and effect?

[vengatvj]

I WANT COPY PASTE MY FORMULA INTO ANOTHER ONE SHEET, WHEN I NEED JUST I COPY AND PAST IN MY EXCEL, IF I COPY PAST IN ANOTHER ONE EXCEL MY FORMULA GOT ERROR, location changed automatically, i want paste in another one excel from without changing address location.

my formula is ="CUG "&"("&K3267&" / "&K3268&" / "&K3269&")"

i want copy this in another one sheet, when i need this i will copy from that, but i cant do this, if i past this locations "K3268" changed
it paste like this ="CUG "&"("&#REF!&" / "&#REF!&" / "&#REF!&")" i cant copy again and paste in original location..

[vengatvj]

my excel very slow so that only when i need this formula in a column just i add, otherwise it should be blank empty cell.. where to save formula and paste it when i need

[newdoverman]

In the original worksheet, click on the cell with the formula. Select the formula in the formula bar and copy. Hit Esc key. Go to the other sheet and paste into the cell where you want the formula.

[vengatvj]

your idea is good, i can able to copy and past in another one sheet, if again copy and past in my original sheet it wont work, because the base address is not changed so that only. is there anyother way to insert formula? from anyother source? just i need formula wen i need only

[newdoverman]

Activate the clipboard and when you copy, the copy is added to the clipboard and is there when you want it. You will find the clipboard on the Home tab.

[minnesotaart]

You can also "save" the formula in a cell someplace and copy it from there only when you need it.

F2 to edit the formula. In front of the = sign place a single quote (') and hit Enter. This saves the formula in that cell as text. Now, copy the formula to wherever you want to store it. It will stay there as text. Go back to the original cell and remove the single quote to reactivate the formula in that cell.

Now, whenever you need the formula, just copy it from the storage cell to the cell where you want it and "activate" it by removing the single quote.