Under Options "Link" is selected. Under Selection "Paste all" is selected. I
am copying a column that has formulas in it. The answer to the formula is
Pasted, not the formula itself. At the top of the heading is a name. The name
which is text can not be found with the "Find & Replace" function.
S Perry <[EMAIL PROTECTED]> wrote: What aspect of "Paste Special" are you
using, i.e. as text...? When you search (Ctrl F), are you searching for numbers
or text?
Walter Hildebrandt wrote:
I do a Paste Special and the cells paste properly. When I do a Find & Replace
the pasted cells are not found when the Find button is clicked. The original
cells from which the Copy was done appear when the Find button is clicked. (I
do a Find on the whole spreadsheet, that is, I start over again when I reach
the end of the spreadsheet so the whole spreadsheet has been searched by the
Find button) How can I do a Copy and Paste Special and have the pasted cells
appear when the Find & Replace feature is used?
---------------------------------
Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.
---------------------------------
Get easy, one-click access to your favorites. Make Yahoo! your homepage.
---------------------------------
Get easy, one-click access to your favorites. Make Yahoo! your homepage.
