I need Excel Help

[SC_RedskinsFan]

I need help on excel making a formula for a general ledger. Here is the one i am using =+G25-F26 but when i go to the next line for it to do the same thing i have to enter the formula again. Is there a way to keep the same formula going down the page?

Somebody help me!!:D

[BigMike619]

you need more then excel help!!

[GoSkins561]

copy, left click and select the area that you would like your formula, (if it is in multplie areas instead of one column, use the control key) right click, then select paste special, then select formula.

[SC_RedskinsFan]

Thanks Mike :finger:

[addicted]

I need help on excel making a formula for a general ledger. Here is the one i am using =+G25-F26 but when i go to the next line for it to do the same thing i have to enter the formula again. Is there a way to keep the same formula going down the page?

Somebody help me!!:D

Just drag your mouse over the cell into the next cell you want if they are in sequential order and it will adjust accordingly. You know what I mean?

[SC_RedskinsFan]

I got it thanks everybody.

[Pwyl]

Just drag your mouse over the cell into the next cell you want if they are in sequential order and it will adjust accordingly. You know what I mean?

If you're talking about drag-filling you have to grab the bottom right corner of the cell to drag. Your cursor will change from a big fat white plus sign to a skinny black one.

Also if you want any part of your reference cell(s) to not change you can click in that reference and hit F4 to toggle through the options.

ie if you want to add the contents of B1 to a range of cells (say in column A starting at row 3) you would make your formula "=A3 + B1" and then change the B1 to $B$1. That way it doesn't "adjust" as you fill in down the column.