"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
|