Member Avatar for Tromba

For some reason, Excel won't allow me to paste into the find or replace dialog. This is more than a little inconvenient. Am I missing something? Has anyone seen this before? Is there a fix or workaround?

TIA!

  • 4 Contributors
  • 5 Replies
  • 507 Views
  • 9 Years Discussion Span
  • Latest Post Latest Post by logan.calder.9

Dani AI

Generated

A short expert summary and practical fixes tied to the replies by , , and .

The symptoms described on this thread usually come down to one of three things: the Find/Replace dialog not having keyboard focus, Excel being in a cell-edit mode so paste targets the sheet, or the clipboard holding formatted/HTML content that the dialog won’t accept. The thread discussion and follow-ups make the same pattern clear, so troubleshooting should start with focus and clipboard-format checks. (daniweb.com)

Quick diagnostic steps and keyboard tips:

  • Exit any cell-edit mode first (press Escape or click a different cell), then open Find/Replace. In Excel, edit vs. enter modes change what paste will do, so make sure a cell is not open for editing.
  • Click the Find (or Replace) text field and verify the caret is visible, then use the Mac paste shortcut (Command‑V).
  • If Tab doesn’t move focus into the dialog controls, enable macOS “Full Keyboard Access” (System Preferences → Keyboard → Shortcuts → All Controls) so you can Tab into the field. Modal dialogs can prevent normal menu actions while they’re waiting for input; that explains why Edit→Paste may appear disabled. (functionx.com)

Workarounds when paste still misbehaves:

  • Strip formatting: paste the copied text into a plain‑text app (TextEdit in plain‑text mode), re-copy and then paste into the Find box. Copying from Google Sheets or a web page can put HTML/RTF on the clipboard which sometimes won’t land in single-line dialog fields. (learn.microsoft.com)

  • Use a small VBA Replace macro so the Find/Replace strings come from worksheet cells (paste your long strings into A1/B1, then run the macro). Example:

    Sub ReplaceFromCells()
  Dim findText As String, replText As String
  With ActiveSheet
    findText = .Range("A1").Value
    replText = .Range("B1").Value
    If Len(findText) = 0 Then MsgBox "Paste Find text into A1": Exit Sub
    .UsedRange.Replace What:=findText, Replacement:=replText, LookAt:=xlPart, MatchCase:=False
  End With
End Sub

    The VBA Range.Replace method is the documented way to perform programmatic replaces; test on a copy and restrict the range if needed. (learn.microsoft.com)

Additional notes: basic troubleshooting (restart Excel/OS, update Office) is often helpful when clipboard behaviour is flaky. ’s advice to rely on keyboard shortcuts is sound; on macOS use Command rather than Ctrl. (learn.microsoft.com)

Recommended Answers

All 5 Replies

Member Avatar for kc0arf

Hello,

The usual things apply: OS version, Office version. How are you trying to paste? Please let us know the exact steps.

Christian

Member Avatar for Tromba

Hello,

The usual things apply: OS version, Office version. How are you trying to paste? Please let us know the exact steps.

Christian

OS X 10.2.8
MS Excel X v10.0

After selecting Edit > Find (or cmd-f) or Edit > Replace, I cannot paste from the clipboard into the fields in the Find or Replace dialog, by either cmd-v or by Edit > Paste. In the case of Edit > Paste, the option to paste is not even available (i.e., it is "grayed out"). Thanks!

Member Avatar for kc0arf

Hi,

What are the contents of the copy? What are you selecting when you hit cmd-c or cmd-v? What I am getting at is are you trying to copy a graphic into a text cell, or something strange like that.

I have also found out that in XL that you do not want to select "destination cells".

Christian

Member Avatar for random1970

I realise this is an old, old thread, but the solution to it, and many others like it, is lose the mouse. Use keyboard shortcuts - CTRL - C to copy, CTRL - V to paste, instead.

Member Avatar for logan.calder.9

I have the same problem. When I copy (cmd+c on a mac) information from a google sheet, and try to paste into the "find" box, the information is instead pasted into the sheet, not the "find" box that I just selected... So confusing, and kind of very annoying.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.