Formula

M

MAS

I want to use a formula for addition and subtraction which will be repeated
on the whole sheet. example C2=C1+A2-A2.This will be repeated in every cell.
How can I do once and don't have to repeat all the times for whole month.
 
D

David Biddulph

Copy, and paste.
If you want some or all of the cell references to stay unchanged as you
copy, look in help for the difference between relative and absolute
addressing.
 

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

Removing a repeated words 0
Copy addition formula of non-consecutive horizontal cells 2
Excel - Wich Function should I use? 1
VBA Coding Help for Beginner 0
SIMPLE DRAGGING issue 1
Development combinations with exclusion of columns 0
complicated excel formula may need an algebra wiz 1
Sharepoint not capturing staff name when automation runs 0

Top