Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Visible Cells Only
When using the filter function in Office 2003, the "drag and drop" method of
copying and pasting defaulted to paste only on those cells that were currently visible based on the filter constraints. In Office 2007, the default is to paste onto EVERY cell, regardless of whether it is currently visible. I know that I can turn on the "Visible Cells Only" function through "Find & Select", "Go To Special", but how do I make that PERMANENT?? Even within the same session of the same worksheet, it turns itself off again as soon as I re-filter. I deals with tens of thousands of lines of data and this is causing me tons of problems. PLEASE HELP!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Visible Cells in Sheet with Merged and Hidden Cells | Excel Discussion (Misc queries) | |||
sum visible cells | Excel Discussion (Misc queries) | |||
Sum visible cells only | Excel Discussion (Misc queries) | |||
Sum of visible cells only | Excel Worksheet Functions | |||
sum only visible cells | Excel Worksheet Functions |