Excel & Copying Formulas

J

JComer

While working in Excel, how do you keep some of the formula constant while
copying and pasting? For example, when copying the formula =sum(B7+C8)-A40
from one cell to another, how do you keep the A40 constant so that no matter
what cell it is in it will always subtract A40?
 

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

Autofill summary worksheet 8
Copy addition formula of non-consecutive horizontal cells 2
How to remove a bracket that is itallicised for an entire document 1
Autonumber field in Excel that behaves the same as Access 0
sumproduct - cell reference 4
get value from cell value 4 rows above in the same column 4
Excel 2010 countifs for date range 3
Paste to excel from word - auto format problem 1

Top