| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i copy formula down columns avoiding hidden cells
hello, i need to copy a formula down a column in a spread sheet, but i need
to avoid putting it in to cells that i have filtered out. Is this possible to do? any help would be great. |
|
#2
|
|||
|
|||
|
Just fill it down through unfiltered rows and you will see that hidden rows
remain unfilled! Regards, Stefi €˛PETE€¯ ezt Ć*rta: hello, i need to copy a formula down a column in a spread sheet, but i need to avoid putting it in to cells that i have filtered out. Is this possible to do? any help would be great. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
| Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
| Changing the columns to copy | Excel Worksheet Functions | |||
| How do you copy a formula without incrementing some constants? | Excel Worksheet Functions | |||
| Copy a Formula down with a Twist Q | Excel Worksheet Functions | |||
Linear Mode
