Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if you drag the fill handle will it decrement the series
if you drag the fill handle it will decrement the series
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if you drag the fill handle will it decrement the series
On Wed, 31 Jan 2007 01:38:00 -0000, ajbanana
wrote: if you drag the fill handle it will decrement the series if you drag upwards -- Steve (3) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if you drag the fill handle will it decrement the series
Ajbanana,
I think you're asking if there's a way to get it to decrement. If you put in the first two numbers in the first two cells, select them, then drag the fill handle, it will continue the series. If your first two numbers are decrementing, it will continue. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "ajbanana" wrote in message ... if you drag the fill handle it will decrement the series |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
if you drag the fill handle will it decrement the series
Yes.
if you select the cell value say 10, and press control and move the fill handle up the cells, the value gets decremented - 9, 8, 7, 6, 5 and so on. If you select the cell value say 10, and press control and move the fill handle down the cells values gets incremented- 11, 12. 13, 14 and so on. Note: If you you decrement beyond the base value - in this case assuming it is 10 -Excel will display negative value. Challa Prabhu "ajbanana" wrote: if you drag the fill handle it will decrement the series |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trend using the same formula as the fill handle does | Excel Worksheet Functions | |||
Fill Handle Across Columns | Excel Discussion (Misc queries) | |||
auto fill series | Excel Discussion (Misc queries) | |||
fill series grayed out (not available, disactivated) | Excel Discussion (Misc queries) | |||
3-d reference not adjusting when using Fill Handle to copy down | Excel Worksheet Functions |