Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"ignoring" hidden cells in a copy/paste operation
I seem to remember in past versions that I could specify that I wished only
to select values in visible cells for the purpose of copying/pasting elsewhere. It doesn't seem to be an option anymore so how is it to be done now? For example, values may be invisible because the column or row is hidden, or because outlining is being used. How do I in that case, select only the values that are visible please? TIA ... Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Odd error - "This operation requires merged cells..." | New Users to Excel | |||
Can't copy & paste - "merged cells must be identically sized" | Excel Discussion (Misc queries) | |||
Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |