Pasting the actual text of a cell - Excel 1

[Joe1010]

Is there a way to paste the actual text of a cell (e.g. IF statement, calculation of some fields) not the formulas or values without adding the $?
Example

A1 =Sheet1!C128
A2 =Sheet1!C129

When I copy row 1 and 2 into row 10 and 11 it will get a mapping of
A10 =Sheet1!C138
A11 =Sheet1!C139

I want it to stay
A10 =Sheet1!C128
A11 =Sheet1!C129

How can this be done?

I’m using Office 2002

Thanks

 

[SkipVought]

Hi,

Edit > Paste Special - VALUES

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[Joe1010]

Let me repeat the question.
I do not need the values of the first field. I want to copy the exact calculation again, the same if statement. See example above.
Thanks

 

[SkipVought]

that's NOT the Actual Text.
[tt]
A1 =Sheet1!C128
A2 =Sheet1!C129
[/tt]
in the FORMULA BAR, select the RANGE

hit the F4 key and notice how it toggles in a cycle...
[tt]
absolute row absolute column ($A$1)
absolute row relative column (A$1)
relative row absolute column ($A1)
relative row relative column (A1)
[/tt]
you want absolute absolute


Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[Joe1010]

Are you sure it is F4? Nothing happens by me.

Is that function adding / removing the $ ??? If so that is what I’m looking for

 

[Joe1010]

Sorry, it works. Thanks thanks

 

[AnotherHiggins]

Is there a way to paste the actual text of a cell (e.g. IF statement, calculation of some fields) not the formulas or values without adding the $?

As Skip explained, the $s denote Absolute References. Without those dollar signs, copying and pasting defaults to Relative References.

But just as an FYI, when the $s aren't present:

-Copying one cell and Pasting to another cell results in the changes you describe. That's Relative Referencing.

-Cutting one cell and Pasting to another cell results in what you're after. But you lose the formula in the original cell.

- Double Clicking in one cell (or pressing [F2]), selecting the entire formula, copying ([Ctrl]+[C]), then pasting to another cell will also act as you wish. But this is rather tedious and can only be done on one cell at a time.


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[Joe1010]

Sorry again,
YES it works; however, I’m able to it for one cell at a time. Is there a way do it for multiple cells at once?
Thanks

 

[Joe1010]

And to clarify my question, I have no problem if it will copied with the $s (if it can be removed quickly) I didn’t know that there is an f4 function that can add/remove the $s.
The only thing is that I’m looking to see how I can add/remove the $s for multiple cells at once.
Thanks

 

[AnotherHiggins]

Can't be done without a macro as far as I know. Sorry.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[GlennUK]

ASAP utilities does that:

http://www.asap-utilities.com/download-asap-utilities.php

You are supposed to buy a license if you are using it in a commercial organisation.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[onedtent]

If your formulas are similar then u can select cells with formulas and go to edit, replace and find !C and replace with !$C$

- onedtent OneDTenT One D Ten T (1D10T)
Not a complete idiot. Some parts are still missing.