Need help exporting/copying 'Find All' results

[tamtammg]

Hi guys, I need some help exporting the 'Find and Replace - Find All' results. Ideally, I would like to export the result table (column Book, Sheet, Name, Cell, and Value) to another table. I've tried selecting all of the results, then do a copy and paste. But copy/paste does not work.

Thanks in advance for any guidance you all have, the need to do this keeps coming back and I'm frustrated.

*the screen capture is for a dummy keyword

 

[Sufiyan97]

Hi guys, I need some help exporting the 'Find and Replace - Find All' results. Ideally, I would like to export the result table (column Book, Sheet, Name, Cell, and Value) to another table. I've tried selecting all of the results, then do a copy and paste. But copy/paste does not work.

Thanks in advance for any guidance you all have, the need to do this keeps coming back and I'm frustrated.

*the screen capture is for a dummy keyword

Try one by one steps

Book3
	F	G
7	Press the following key sequences:
8	1. Ctrl+h (open Find-Replace window)	Ctrl+h
9	2. Alt+t (open Options)	Alt+t
10	3. Alt+o (check the box for : Match entire cell content)	Alt+o
11	4. Alt+n (Find field, type here a zero, or whatever you want to replace)	Alt+n
12	6. Alt+i (the keyboard equivalent of Find All button)	Alt+i
13	7. Ctrl+a (this will select all cells found by Find All action)	Ctrl+a
14	7. Alt+F4 (close the Find-Replace window.	Alt+F4
Sheet1