Quickest way to input formulas?
If you need to put a standard formula into a column with around 10000 rows, is there a quicker way of inputing the formula into each cell rather than having to right click and drag your cursor down 10000 lines or is that the quickest way???? Any handy tips would be great!!! Thanks -- Aoife101 ------------------------------------------------------------------------ Aoife101's Profile: http://www.excelforum.com/member.php...o&userid=35928 View this thread: http://www.excelforum.com/showthread...hreadid=563170 |
Quickest way to input formulas?
Hi Aoife,
If the formula's column is immediately adjacent a column with data that reaches down that far then double clicking when the cursor changes to the finer filldown cursor will fill down the same number of rows as the data in the adjacent column. If the above condition doesn't apply then select the top cell with the formula then go Edit|Go to... type the address of the last cell for the formula into the Reference box, then hold down the Shift key while you click OK|Control + D|Control + Up Arrow to return to top of sheet. Ken Johnson |
Quickest way to input formulas?
Select the range to get the formula
either via: Edit|goto, F5, or just typing the address in the NameBox (to the left of the formula bar). Type your formula for the activecell in that selection (usually the top cell--unless you did something else) But hit ctrl-enter instead of just enter. The cells will be filled with the adjusted formula--just like dragging it down. You can do this with just plain old constants, too. Aoife101 wrote: If you need to put a standard formula into a column with around 10000 rows, is there a quicker way of inputing the formula into each cell rather than having to right click and drag your cursor down 10000 lines or is that the quickest way???? Any handy tips would be great!!! Thanks -- Aoife101 ------------------------------------------------------------------------ Aoife101's Profile: http://www.excelforum.com/member.php...o&userid=35928 View this thread: http://www.excelforum.com/showthread...hreadid=563170 -- Dave Peterson |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com