ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Find/Replace in multiple worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/135929-find-replace-multiple-worksheets.html)

Lynn

Find/Replace in multiple worksheets
 
Is there a way to use the Find/Replace feature in multiple workbooks at the
same time? I know you can search an entire workbook with this feature, but I
want to look through several workbooks.

Thanks.

JR

Find/Replace in multiple worksheets
 
Lynn:
Hold down Ctrl and click the tabs of the sheets you would like to select.
Then press Ctrl H to open the Find/Replace dialogue box.

"Lynn" wrote:

Is there a way to use the Find/Replace feature in multiple workbooks at the
same time? I know you can search an entire workbook with this feature, but I
want to look through several workbooks.

Thanks.



All times are GMT +1. The time now is 03:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com