keep a cell used in a formula constant when pasteing into another.

G

Gord Dibben

Rob

Have a look in Help for "about cell and range references" which explains the
difference between Absolute and Relative references.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove a bracket that is itallicised for an entire document 1
Copy addition formula of non-consecutive horizontal cells 2
Word doc keeps changing to ALL CAPS 0
Pages are changing pasted image... 0
Mapping integers to strings 6
Using formula to convert date result to text 3
Formula constants? 2
What happened to setting up a constant using F4? 2

Top