SC_RedskinsFan Posted January 15, 2009 Share Posted January 15, 2009 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!! Link to comment Share on other sites More sharing options...
BigMike619 Posted January 15, 2009 Share Posted January 15, 2009 you need more then excel help!! Link to comment Share on other sites More sharing options...
GoSkins561 Posted January 15, 2009 Share Posted January 15, 2009 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. Link to comment Share on other sites More sharing options...
SC_RedskinsFan Posted January 15, 2009 Author Share Posted January 15, 2009 Thanks Mike :finger: Link to comment Share on other sites More sharing options...
addicted Posted January 15, 2009 Share Posted January 15, 2009 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!! 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? Link to comment Share on other sites More sharing options...
SC_RedskinsFan Posted January 15, 2009 Author Share Posted January 15, 2009 I got it thanks everybody. Link to comment Share on other sites More sharing options...
Pwyl Posted January 15, 2009 Share Posted January 15, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.