formula for entire colum

S

sigfreund

Sorry to have to ask such a basic question, but how do I apply a formul
to an entire colum? I want c3=c2+a3-b3, c4=c3+a4-b4, c5=c4+a5-b5, .
 
D

Doug Kanter

sigfreund said:
Sorry to have to ask such a basic question, but how do I apply a formula
to an entire colum? I want c3=c2+a3-b3, c4=c3+a4-b4, c5=c4+a5-b5, . .
Click to expand...

Just copy & paste. Excel will increment the formula for each line.
 

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

PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
conditional sum? 2
change change cell reference to Absolute reference 5
repost: conditional sum? 5
LOOPING STRUCTURE DESIRED 4 TWO RANGES 2
if statement 2
Excel Fill issue 2
IF function 5

Top