Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Formulas | Excel Discussion (Misc queries) | |||
Macro to copy range of formulas to equal data lines | Excel Worksheet Functions | |||
How do you apply Names in formulas? | Excel Discussion (Misc queries) | |||
locking formulas?? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |