Simple Formula Question - Urgently need your help!!

B

biggest_apple

hi,

I have the following simple formula: =A61*E61

I need to know how I can highlight a block of cells - Let's say row
62-86 and have that formula update itself to reflect each row number
(A column & E column remain throughout only the numbers of the row
change)

Hope that made sense. I know it's a simple proceedure I just can'
remember how to do it. Your help would be greatly appreciated as I'
really up against a deadline.

Thanks!! :
 
F

Frank Kabel

just copy the formula for all rows. Excel will change the formula
accordingly
Frank
 

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

Top