pasting exact cell references

  • Thread starter Thread starter isaac
  • Start date Start date
I

isaac

Whenever I cut and paste a cell reference, the pasted value always
gets adjusted relative to the location of the original cell to its
reference. For example, say cell A1 refers to cell B1. If I copy
and paste A1's contents into A2, A2 will refer to B2, not B1.
Usually this is a handy feature, but is there a quick way to paste
exact cell refernces? ( so that A2 shows B1's contents )?

Thanks,
Isaac
 
You can copy from the formula bar or if you have a rather large range of
cells
you can turn the formula to strings and then back, one way
select the range do edit>replace and in find what put the equal sign =
in the replace with put xx=, click replace all. now copy the cells you want
and paste them wherever you want, then revert by replacing xx= with =
 
You can make the reference to cell B1 absolute. In cell
A1 type dollar signs preceding both the column letter and
the row number, such as =$B$1. When this is copied from
cell A1 and pasted anywhere in the spreadsheet, the
formula will continue to refer back to cell B1.
 
Back
Top