Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter and autofill series number
1. I applied filters in my excel
2. I need to put series of number 3. By using this " =COUNTIF(Z$1:Z19,"<") " formula we can able to fill the number series when the filters are applied for the excel. But this working fine when we drag the same for the rest of the column 4. I need to a solution for the same scenario when we double click on the right corner of the selected cells (to autofill the number series for the remaining cells instead of draggging) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter and autofill series number
I'm afraid I am unable to duplicate your problem. When I filter data, and
then create a formula, I can drag/double click just fine to autofill the series. Is there some specific reason you are not using formula throughout entire column? Your other option would be to copy and paste. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Silpa" wrote: 1. I applied filters in my excel 2. I need to put series of number 3. By using this " =COUNTIF(Z$1:Z19,"<") " formula we can able to fill the number series when the filters are applied for the excel. But this working fine when we drag the same for the rest of the column 4. I need to a solution for the same scenario when we double click on the right corner of the selected cells (to autofill the number series for the remaining cells instead of draggging) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to put series of number in excel when the filter is applied? | Excel Discussion (Misc queries) | |||
AutoFill a series to last row in dataset | Excel Discussion (Misc queries) | |||
autofill series | Excel Worksheet Functions | |||
Series of web queries: Autofill? | Excel Discussion (Misc queries) | |||
Autofill a series | Excel Worksheet Functions |