| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel Auto Fill Handles
I have a formula in C2 which calculates data from A2 and B2. I can
double-click the lower right "handle" in C2 and if I have data in columns A and B, rows 3 through ??, that will copy my formula down and fill values (i.e. through C500) until a blank row is found. Now what if I want to copy a fromula horizontally across many columns until it finds a blank column? If I double click the lower right "handle" I get no response. Is there an option to check to allow this functionality or is it non-existent? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel Auto Fill Handles
Rachel
No such functionality to fill across rows that I ever heard of. Gord Dibben MS Excel MVP On Wed, 12 Jul 2006 13:36:02 -0700, RachelN wrote: I have a formula in C2 which calculates data from A2 and B2. I can double-click the lower right "handle" in C2 and if I have data in columns A and B, rows 3 through ??, that will copy my formula down and fill values (i.e. through C500) until a blank row is found. Now what if I want to copy a fromula horizontally across many columns until it finds a blank column? If I double click the lower right "handle" I get no response. Is there an option to check to allow this functionality or is it non-existent? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| stop auto fill from thinking for itself!!!!!!! | New Users to Excel | |||
| How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
| autoshape fill problems in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
| Auto Fill Options | Excel Discussion (Misc queries) | |||
Linear Mode
