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

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

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

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

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

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