Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toggle between Find and Replace
Hello
I am using Excel 2003 SP2 and have several workbooks open in the application. However I am using the find and replace function. Is there a way to toggle between the workbook you are working on and the find and replace window using the keyboard only (without having to esc and reopen with Ctrl+H)? Any ideas appreciated. Thank you, Nav |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toggle between Find and Replace
Well, you would be able to open Find with Ctrl+F, then Alt+P goes to Replace,
then Alt+R will perform the replace command. Once you have it open, you can use Alt+Tab to swap between workbooks. Don't close the Find/replace box. It'll stay open and only replace within the active workbook... "Nav" wrote: Hello I am using Excel 2003 SP2 and have several workbooks open in the application. However I am using the find and replace function. Is there a way to toggle between the workbook you are working on and the find and replace window using the keyboard only (without having to esc and reopen with Ctrl+H)? Any ideas appreciated. Thank you, Nav |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toggle between Find and Replace
Hello Sean
Thank you for your response - however I need to toggle between the current workbok and the Find and Replace window in the same workbook. Is there a way of doing this as Alt+tab toggles between the workbooks as opposed to the Find and Replace and the current Workbook. Thank you in advance for any ideas. Regards, Nav "Sean Timmons" wrote: Well, you would be able to open Find with Ctrl+F, then Alt+P goes to Replace, then Alt+R will perform the replace command. Once you have it open, you can use Alt+Tab to swap between workbooks. Don't close the Find/replace box. It'll stay open and only replace within the active workbook... "Nav" wrote: Hello I am using Excel 2003 SP2 and have several workbooks open in the application. However I am using the find and replace function. Is there a way to toggle between the workbook you are working on and the find and replace window using the keyboard only (without having to esc and reopen with Ctrl+H)? Any ideas appreciated. Thank you, Nav |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toggle between Find and Replace
I would think using Esc to jump out of F&R, then Ctrl+F to pull it back up
should be relatively quick and easy. "Nav" wrote: Hello Sean Thank you for your response - however I need to toggle between the current workbok and the Find and Replace window in the same workbook. Is there a way of doing this as Alt+tab toggles between the workbooks as opposed to the Find and Replace and the current Workbook. Thank you in advance for any ideas. Regards, Nav "Sean Timmons" wrote: Well, you would be able to open Find with Ctrl+F, then Alt+P goes to Replace, then Alt+R will perform the replace command. Once you have it open, you can use Alt+Tab to swap between workbooks. Don't close the Find/replace box. It'll stay open and only replace within the active workbook... "Nav" wrote: Hello I am using Excel 2003 SP2 and have several workbooks open in the application. However I am using the find and replace function. Is there a way to toggle between the workbook you are working on and the find and replace window using the keyboard only (without having to esc and reopen with Ctrl+H)? Any ideas appreciated. Thank you, Nav |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toggle between Find and Replace
If you would prefer to make a shortcut, you can create a macro. Just perform
the escape and give it a hot key. "Sean Timmons" wrote: I would think using Esc to jump out of F&R, then Ctrl+F to pull it back up should be relatively quick and easy. "Nav" wrote: Hello Sean Thank you for your response - however I need to toggle between the current workbok and the Find and Replace window in the same workbook. Is there a way of doing this as Alt+tab toggles between the workbooks as opposed to the Find and Replace and the current Workbook. Thank you in advance for any ideas. Regards, Nav "Sean Timmons" wrote: Well, you would be able to open Find with Ctrl+F, then Alt+P goes to Replace, then Alt+R will perform the replace command. Once you have it open, you can use Alt+Tab to swap between workbooks. Don't close the Find/replace box. It'll stay open and only replace within the active workbook... "Nav" wrote: Hello I am using Excel 2003 SP2 and have several workbooks open in the application. However I am using the find and replace function. Is there a way to toggle between the workbook you are working on and the find and replace window using the keyboard only (without having to esc and reopen with Ctrl+H)? Any ideas appreciated. Thank you, Nav |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
HOW DO I TOGGLE FROM FIND AND REPLACE TO A CELL EASILY? | Excel Discussion (Misc queries) | |||
find replace cursor default to find box | Excel Discussion (Misc queries) |