Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace
If i'm in the Find and Replace box how do I go back to the worksheet that I'm
working on? Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace
Either click the close button if you want it to go away, or select the sheet
tab in Excel. The find & replace box will become passive while you navigate in XL. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teelee" wrote: If i'm in the Find and Replace box how do I go back to the worksheet that I'm working on? Thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace
When I tab it's stays at the find and replace box. What do you mean the sheet
tab? Thanks "Luke M" wrote: Either click the close button if you want it to go away, or select the sheet tab in Excel. The find & replace box will become passive while you navigate in XL. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teelee" wrote: If i'm in the Find and Replace box how do I go back to the worksheet that I'm working on? Thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace
Hi teelee
Assuming you are on sheet3 while already executed the Find/Replace dialog and want go to sheet1, you need to click on the sheet tab of sheet1 and EXcel will bring you there without the need to close the Find/Replace. HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "teelee" wrote: When I tab it's stays at the find and replace box. What do you mean the sheet tab? Thanks "Luke M" wrote: Either click the close button if you want it to go away, or select the sheet tab in Excel. The find & replace box will become passive while you navigate in XL. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teelee" wrote: If i'm in the Find and Replace box how do I go back to the worksheet that I'm working on? Thanks in advance |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace
Yes I understand that but what I was trying to avoid was using the mouse from
going to find and replace to my worksheet. I know once I'm in the worksheet I can use ctrl f which brings me back to the find & replace, but is there away to go from the find & replace to my worksheet without using the mouse? Thanks "xlm" wrote: Hi teelee Assuming you are on sheet3 while already executed the Find/Replace dialog and want go to sheet1, you need to click on the sheet tab of sheet1 and EXcel will bring you there without the need to close the Find/Replace. HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "teelee" wrote: When I tab it's stays at the find and replace box. What do you mean the sheet tab? Thanks "Luke M" wrote: Either click the close button if you want it to go away, or select the sheet tab in Excel. The find & replace box will become passive while you navigate in XL. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teelee" wrote: If i'm in the Find and Replace box how do I go back to the worksheet that I'm working on? Thanks in advance |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace
Do the following
when you have your Find/Replace executed press Alt + F6, this will bring the focus back to the worksheet if you are on a sheet and want to move to another sheet, press Ctrl + Page Up / Page down to bring focus back to your Find/Replace press Ctrl + F Is this what you are after? HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "teelee" wrote: Yes I understand that but what I was trying to avoid was using the mouse from going to find and replace to my worksheet. I know once I'm in the worksheet I can use ctrl f which brings me back to the find & replace, but is there away to go from the find & replace to my worksheet without using the mouse? Thanks "xlm" wrote: Hi teelee Assuming you are on sheet3 while already executed the Find/Replace dialog and want go to sheet1, you need to click on the sheet tab of sheet1 and EXcel will bring you there without the need to close the Find/Replace. HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "teelee" wrote: When I tab it's stays at the find and replace box. What do you mean the sheet tab? Thanks "Luke M" wrote: Either click the close button if you want it to go away, or select the sheet tab in Excel. The find & replace box will become passive while you navigate in XL. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teelee" wrote: If i'm in the Find and Replace box how do I go back to the worksheet that I'm working on? Thanks in advance |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace
Yes this is what I was after, however when I press Alt + F6 nothing happens,
it just stays on the find/replace box. Thanks "xlm" wrote: Do the following when you have your Find/Replace executed press Alt + F6, this will bring the focus back to the worksheet if you are on a sheet and want to move to another sheet, press Ctrl + Page Up / Page down to bring focus back to your Find/Replace press Ctrl + F Is this what you are after? HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "teelee" wrote: Yes I understand that but what I was trying to avoid was using the mouse from going to find and replace to my worksheet. I know once I'm in the worksheet I can use ctrl f which brings me back to the find & replace, but is there away to go from the find & replace to my worksheet without using the mouse? Thanks "xlm" wrote: Hi teelee Assuming you are on sheet3 while already executed the Find/Replace dialog and want go to sheet1, you need to click on the sheet tab of sheet1 and EXcel will bring you there without the need to close the Find/Replace. HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "teelee" wrote: When I tab it's stays at the find and replace box. What do you mean the sheet tab? Thanks "Luke M" wrote: Either click the close button if you want it to go away, or select the sheet tab in Excel. The find & replace box will become passive while you navigate in XL. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teelee" wrote: If i'm in the Find and Replace box how do I go back to the worksheet that I'm working on? Thanks in advance |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace
Hi teelee
Its works on my Excel 2003, pressing both Alt and F6 together will bring you back to the worksheet. Not sure if you are using the same version or would there be differences between version. Pls try again. HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "teelee" wrote: Yes this is what I was after, however when I press Alt + F6 nothing happens, it just stays on the find/replace box. Thanks "xlm" wrote: Do the following when you have your Find/Replace executed press Alt + F6, this will bring the focus back to the worksheet if you are on a sheet and want to move to another sheet, press Ctrl + Page Up / Page down to bring focus back to your Find/Replace press Ctrl + F Is this what you are after? HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "teelee" wrote: Yes I understand that but what I was trying to avoid was using the mouse from going to find and replace to my worksheet. I know once I'm in the worksheet I can use ctrl f which brings me back to the find & replace, but is there away to go from the find & replace to my worksheet without using the mouse? Thanks "xlm" wrote: Hi teelee Assuming you are on sheet3 while already executed the Find/Replace dialog and want go to sheet1, you need to click on the sheet tab of sheet1 and EXcel will bring you there without the need to close the Find/Replace. HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "teelee" wrote: When I tab it's stays at the find and replace box. What do you mean the sheet tab? Thanks "Luke M" wrote: Either click the close button if you want it to go away, or select the sheet tab in Excel. The find & replace box will become passive while you navigate in XL. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teelee" wrote: If i'm in the Find and Replace box how do I go back to the worksheet that I'm working on? Thanks in advance |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace
To close the dialogue box with just keyboard:
Esc or Alt+F4 will work. Using XL2003, I was not able to get Alt+F6 to switch windows either. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teelee" wrote: Yes this is what I was after, however when I press Alt + F6 nothing happens, it just stays on the find/replace box. Thanks "xlm" wrote: Do the following when you have your Find/Replace executed press Alt + F6, this will bring the focus back to the worksheet if you are on a sheet and want to move to another sheet, press Ctrl + Page Up / Page down to bring focus back to your Find/Replace press Ctrl + F Is this what you are after? HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "teelee" wrote: Yes I understand that but what I was trying to avoid was using the mouse from going to find and replace to my worksheet. I know once I'm in the worksheet I can use ctrl f which brings me back to the find & replace, but is there away to go from the find & replace to my worksheet without using the mouse? Thanks "xlm" wrote: Hi teelee Assuming you are on sheet3 while already executed the Find/Replace dialog and want go to sheet1, you need to click on the sheet tab of sheet1 and EXcel will bring you there without the need to close the Find/Replace. HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "teelee" wrote: When I tab it's stays at the find and replace box. What do you mean the sheet tab? Thanks "Luke M" wrote: Either click the close button if you want it to go away, or select the sheet tab in Excel. The find & replace box will become passive while you navigate in XL. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teelee" wrote: If i'm in the Find and Replace box how do I go back to the worksheet that I'm working on? Thanks in advance |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace
I am really not sure then. I am able to use Alt + F6 to switch focus
We are refering to EditFind???. Its works -- If this posting was helpful, please click on the Yes button Thank You cheers, "Luke M" wrote: To close the dialogue box with just keyboard: Esc or Alt+F4 will work. Using XL2003, I was not able to get Alt+F6 to switch windows either. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teelee" wrote: Yes this is what I was after, however when I press Alt + F6 nothing happens, it just stays on the find/replace box. Thanks "xlm" wrote: Do the following when you have your Find/Replace executed press Alt + F6, this will bring the focus back to the worksheet if you are on a sheet and want to move to another sheet, press Ctrl + Page Up / Page down to bring focus back to your Find/Replace press Ctrl + F Is this what you are after? HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "teelee" wrote: Yes I understand that but what I was trying to avoid was using the mouse from going to find and replace to my worksheet. I know once I'm in the worksheet I can use ctrl f which brings me back to the find & replace, but is there away to go from the find & replace to my worksheet without using the mouse? Thanks "xlm" wrote: Hi teelee Assuming you are on sheet3 while already executed the Find/Replace dialog and want go to sheet1, you need to click on the sheet tab of sheet1 and EXcel will bring you there without the need to close the Find/Replace. HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "teelee" wrote: When I tab it's stays at the find and replace box. What do you mean the sheet tab? Thanks "Luke M" wrote: Either click the close button if you want it to go away, or select the sheet tab in Excel. The find & replace box will become passive while you navigate in XL. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "teelee" wrote: If i'm in the Find and Replace box how do I go back to the worksheet that I'm working on? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
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 | |||
find replace cursor default to find box | Excel Discussion (Misc queries) |