Escaping from slavery through linkage

  • Thread starter Thread starter polemeros
  • Start date Start date
P

polemeros

There must be a simple way to do this.

I have a workbook with several worksheets in it.
The first worksheet consists of data copied from a budget.


The cells show a result, eg "$2,653",
but in the formula bar above, what shows is the link/formula,
eg, =June30thResults C34.

When I try to copy "$2,653" to another worksheet and then do something
fancy like tranpose a column into a row, all the data turns to "0".

Is there a way that I can escape slavery to linkage and have the
worksheet turn "=June30thResults C34" into "$2653", and have it stay
that way, just as if I had typed "$2653" directly into the cell in the
first place?

Thanks for any help.
 
Use the Paste Special Command to copy formulas, & paste results as fixed
values. From the Edit Menu:
- Paste Special
- Values Option

To transpose the column oriented formulas to row oriented values, select the
"Transpose" Checkbox with the Values option. (you can do both
simultaneously)

The Paste Special command is also available with a right click.

You may need to reformat those pasted values as the original copied formats
are not retained with the Paste Special | Values command.

To avoid reformatting, from the Edit Menu:
- Paste Special
- Transpose
(Immediately after while the copied cells are still in the Clipboard
buffer)
- Paste Special (again)
- Values & Transpose simultaneously
(If not transposing - just Paste, then Paste Special | Values)
 
Back
Top