Keyboard Shortcut to toggle b/w Find and Replace and Active Worksheet?

Hi:
I open the Find and replace Dialogue Box using CTRL+F and then enter
the value I am looking for.  Excel moves the cursor to the cell in
question with the found value.
Is there anyway to then use the keyboard to move from the dialogue
box
into the actual worksheet, without having to mouse click back into
the
open file?  It seems there has to be some type of way to use the
keyboard to move from the Find Dialogue box without using the mouse.
I hope I am being clear on what I am trying to do, it seems very
simple yet I cannot figure out what keyboard command to use to
basically select the Excel Window while leaving the Find Dialouge box
open.
Thank you. - BWP
0
11/25/2008 2:39:34 PM
excel 39879 articles. 2 followers. Follow

4 Replies
690 Views

Similar Articles

[PageSpeed] 12

This is what I do:

Ctrl-f, enter criteria, press Enter to go to first match.
Then press Esc to close the dialog.
Then use Shift-F4 repeatedly to go to each successive match.
Ctrl-Shift-F4 goes in reverse.

-- 
Jim
"Brooks" <brookswhitmoreparker@gmail.com> wrote in message 
news:6ee13800-bebe-46f1-ab2c-db4f65f1e75a@3g2000yqs.googlegroups.com...
| Hi:
| I open the Find and replace Dialogue Box using CTRL+F and then enter
| the value I am looking for.  Excel moves the cursor to the cell in
| question with the found value.
| Is there anyway to then use the keyboard to move from the dialogue
| box
| into the actual worksheet, without having to mouse click back into
| the
| open file?  It seems there has to be some type of way to use the
| keyboard to move from the Find Dialogue box without using the mouse.
| I hope I am being clear on what I am trying to do, it seems very
| simple yet I cannot figure out what keyboard command to use to
| basically select the Excel Window while leaving the Find Dialouge box
| open.
| Thank you. - BWP 

0
jrrech (1933)
11/25/2008 3:26:01 PM
Hi,

If you are trying to keep the dialog box open the answer is no.  If you just 
want to reach the spreadsheet press Esc.  You can also press Alt+F4 or Tab 
until you reach the Close button and then Enter.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Brooks" wrote:

> Hi:
> I open the Find and replace Dialogue Box using CTRL+F and then enter
> the value I am looking for.  Excel moves the cursor to the cell in
> question with the found value.
> Is there anyway to then use the keyboard to move from the dialogue
> box
> into the actual worksheet, without having to mouse click back into
> the
> open file?  It seems there has to be some type of way to use the
> keyboard to move from the Find Dialogue box without using the mouse.
> I hope I am being clear on what I am trying to do, it seems very
> simple yet I cannot figure out what keyboard command to use to
> basically select the Excel Window while leaving the Find Dialouge box
> open.
> Thank you. - BWP
> 
0
11/26/2008 6:45:00 AM
I have been using excel for past many years but i didn't know that. Thank you 
very much.

Regards.

"Jim Rech" wrote:

> This is what I do:
> 
> Ctrl-f, enter criteria, press Enter to go to first match.
> Then press Esc to close the dialog.
> Then use Shift-F4 repeatedly to go to each successive match.
> Ctrl-Shift-F4 goes in reverse.
> 
> -- 
> Jim
> "Brooks" <brookswhitmoreparker@gmail.com> wrote in message 
> news:6ee13800-bebe-46f1-ab2c-db4f65f1e75a@3g2000yqs.googlegroups.com...
> | Hi:
> | I open the Find and replace Dialogue Box using CTRL+F and then enter
> | the value I am looking for.  Excel moves the cursor to the cell in
> | question with the found value.
> | Is there anyway to then use the keyboard to move from the dialogue
> | box
> | into the actual worksheet, without having to mouse click back into
> | the
> | open file?  It seems there has to be some type of way to use the
> | keyboard to move from the Find Dialogue box without using the mouse.
> | I hope I am being clear on what I am trying to do, it seems very
> | simple yet I cannot figure out what keyboard command to use to
> | basically select the Excel Window while leaving the Find Dialouge box
> | open.
> | Thank you. - BWP 
> 
> 
0
shabutt (12)
11/29/2008 6:57:01 AM
Thanks!  The esc key will suit my needs.

Brooks

On Nov 29, 1:57=A0am, shabutt <shab...@discussions.microsoft.com> wrote:
> I have been using excel for past many years but i didn't know that. Thank=
 you
> very much.
>
> Regards.
>
> "Jim Rech" wrote:
> > This is what I do:
>
> > Ctrl-f, enter criteria, press Enter to go to first match.
> > Then press Esc to close the dialog.
> > Then use Shift-F4 repeatedly to go to each successive match.
> > Ctrl-Shift-F4 goes in reverse.
>
> > --
> > Jim
> > "Brooks" <brookswhitmorepar...@gmail.com> wrote in message
> >news:6ee13800-bebe-46f1-ab2c-db4f65f1e75a@3g2000yqs.googlegroups.com...
> > | Hi:
> > | I open the Find and replace Dialogue Box using CTRL+F and then enter
> > | the value I am looking for. =A0Excel moves the cursor to the cell in
> > | question with the found value.
> > | Is there anyway to then use the keyboard to move from the dialogue
> > | box
> > | into the actual worksheet, without having to mouse click back into
> > | the
> > | open file? =A0It seems there has to be some type of way to use the
> > | keyboard to move from the Find Dialogue box without using the mouse.
> > | I hope I am being clear on what I am trying to do, it seems very
> > | simple yet I cannot figure out what keyboard command to use to
> > | basically select the Excel Window while leaving the Find Dialouge box
> > | open.
> > | Thank you. - BWP

0
12/1/2008 1:00:42 AM
Reply:

Similar Artilces:

English keyboard
Hi All, How can I switch the keyboard to English (or to any other) from Access ? Thanks in advance Imre ...

adding a "relationship code" to a worksheet
Hi. what I mean by "relationship code" is this. a relationship between transactions. Here is a sample of what I have and need. Have PO Item Type Material Number MvT Pstg date 12345 10 NB 789 101 1/6/2009 12345 10 NB 789 321 1/8/2009 12345 20 NB ABC 101 1/7/2009 12345 20 NB ABC 101 1/7/2009 12345 20 NB ABC 321 1/8/2009 12345 20 NB ABC 321 1/8/2009 56789 60 NB A1A 101 2/4/2009 56789 60 NB A1A 321 2/5/2009 56789 90 NB AAA ...

Advanced find and replace?
Is there a way to Find and Replace a string by directing excel to a lookup table? I have a big spreadsheet with lots of text strings. I want to find all strings containing "abc", and replace it with "xyz". But I have about 40 such replacements to make, and was wondering if I could direct excel to a 2-column table, where it would see the 40 pairs of strings that I want it to find and replace. I am familiar with >Edit >Replace, but am hoping there is a way to automate and accelarate the task. Any ideas Dan With not too much error checking. Option Explicit Sub tes...

=?Utf-8?B?44Ko44Op44O844GM5Ye644KL?=
out look でエラーがでる Bummer. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After furious head scratching, godman4018@ybb.ne.jp asked: | out look でエラーがでる ...

Keyboard
Hi, I need to catch the keyboard key`s ctrl+alt+e in my MFC application how can I catch the combination of those three key`s??? How can I catch the F5 key??? For a normal key`s I use appwizard OnChar function or KeyDown. Thanks. hi, I guess you can try GetKeyState(VK_MENU) and GetKeyState(VK_CONTROL) when you response the OnChar or KeyDown message. "Dave" wrote: > Hi, > I need to catch the keyboard key`s ctrl+alt+e in my MFC application > how can I catch the combination of those three key`s??? > > How can I catch the F5 key??? > > &...

hook keyboard and send as other keyvalue
hi, i have a problem to deal with global keyboard hooking . my application has to deal with a special keyboard, whitch asking that when press Shilft + A, it actually come out "#", Shift + B , it comes out "&".. and when shift is not pressed, the A is still A. i can not come out with the functionality no matter what.. i have to use global keyboard hooking since it is for the whole application LRESULT CALLBACK keyProc(int nCode,WPARAM wParam,LPARAM lParam) { PKBDLLHOOKSTRUCT hook = (PKBDLLHOOKSTRUCT)lParam; ??????? return CallNextHookEx(gHook, nCode, wPa...

can't find IMF setup in Exchange 2003 sp2
Dear all, After I upgrade to Exchange 2003 sp2, I can't find IMF setup option in SMTP virtual server. I've try re-install IMF but not work. Is that because sp2 remove IMF setup option in SMTP virtual server? Many thanks for your help! On Thu, 20 Oct 2005 07:34:07 +0800, "Staff" <user@normal.com.nospam> wrote: >Dear all, > >After I upgrade to Exchange 2003 sp2, I can't find IMF setup option in SMTP >virtual server. > >I've try re-install IMF but not work. Is that because sp2 remove IMF setup >option in SMTP virtual server? > &...

how do i create a path to a worksheet from outside of excel
i am creating a stand alone application with flash from within the app i've created links to open a excel file this works no problem what doesn't work is trying to access specific worksheets within the excel file the file path i'm using is... guidebook.xls#'2.2'!A1 where '2.2' is the name of the worksheet what is the correct file path to not only open a excel file but to open a specific worksheet within that file??? ...

Exporting query w/ parameter to Excel
Hello, I have a query that I run from a Command Button on my Switchboard that I ultimately need to export to Excel. When I click on the Command Button (using 'DoCmd.OpenQuery'), the prompt appears, and after it is answered by the user, the query runs fine. But when I go to File... Export... the parameter prompt appears again before allowing the actual export. Can I avoid this 're-prompting', or if there is a better way to make sure the query runs and then exports out to excel, that is even better. It isn't necessary that the user sees the results of the query run...

spam: finding strings inside < >
I am trying to get the rules wizard to match strings in the body of messages, and not having much luck with one kind of string. These are appearing inside of < > html constructs. I just want to catch messages with a given web address, an href if you want to get specific, but nothing seems to work. I've tried strings with: just the hostname, the entire www.host.com string, everything from the href through the end of the .com, and the entire html construct, including the < >. Any ideas? Outlook 2002 on Win 2000. George George Marshall <george@NOSPAMmarshalls.org&g...

Shuts Down When Copying Worksheets
When I right-click on a worksheet tab, choose create a copy and tha past it into a new WORKBOOK Excel completely shuts down -- Message posted from http://www.ExcelForum.com I had that happen once to one of my workbooks. It was just one worksheet in a workbook with many worksheets. My first workaround was to save the original workbook (with the problem sheet). Right click, move or copy, but choose MOVE. excel didn't crash. Close the original workbook without saving. This worked ok for me, but scared the heck out of me. I was using xl97 at work where the problem occurred, and xl2002 a...

Updating worksheet #2
I currently have an excel spreadsheet which queries an access databas and returns the results into a sheet where the data is analysed an stats are produced. I am also returning data to the stats sheet as helper column to enable certain calculations This has worked previously but i have changed the database from whic it queries and all i get in the stats sheet is a lot of #N/A's wher previously the data has been -- Message posted from http://www.ExcelForum.com Hi, It's difficult to say what's happened - what, exactly, did you change in the database? name? location? or columns...

Create an exel 2007 shortcut key
How do I create an excel shortcut key? For instance, I want to create a shortcut key for Moving or Copying a worksheet. I added it to the quick access toolboar, but cannot figure out to create a shortcut key for that command. Thank you for your help. Not sure why you need a shortcut key, when a button is already handy, but here are the instructions from the Excel help file. You'll need to put the command in a macro, then: "To assign a CTRL combination shortcut key to run the macro, in the Shortcut key box [click View Macros - select macro - click Options], type any lowerc...

Mem Leak /w std::string???
Hello, Does anybody recognize these memory leak messages?: .... Detected memory leaks! Dumping objects -> {1844083} normal block at 0x01D921D0, 12 bytes long. Data: < 2 > 98 32 D4 03 00 00 00 00 98 CF DB 03 {1844082} normal block at 0x03B36FC8, 32 bytes long. Data: <Frame Paint Ends> 46 72 61 6D 65 20 50 61 69 6E 74 20 45 6E 64 73 {1844080} normal block at 0x03D43298, 40 bytes long. Data: < Zk o > 88 5A 6B 00 CD CD CD CD C8 6F B3 03 CD CD CD CD {1844078} normal block at 0x03DBCF98, 12 bytes long. Data: <02 ! h > 30 32 D4 03 D0 21 D9 01...

KEYBOARD NOT WORKING
I know some people may help better if I give more specific details to my problem.. So here goes: My keyboard works correctly with any other application, such as MSN, ICQ, Wordpad.. etc. However, when I open an Office application such as Word or Excel, it doesn't seem to type for me. I cannot type in the help section, can I type in the document or in those toolbars at the top for Fonts, etc. But if I specifically go to "Format >> Font", then yes, I can type in it. I have tried reinstalling Office already, that doesn't work. The hardware is fine, I can still...

How can I find strings of wildcards in Excel?
I was looking to find strings made up of wildcard characters in Excel, and I've been having some problems. For example, I was searching for the string "*?" in my spreadsheet (without the quotes), and it was directing me to every cell with data in it. If I search for "{*" (without the quotes), it directs me to every cell with data that begins with the "{" amperscand character. Does anyone have a similar problem, or know how to get around this? Thank you in advance. Hi search for ~* or ~? -- Regards Frank Kabel Frankfurt, Germany "Nick M" &...

vba replace for improper page breaks in Word 2003
We are receiving thousands of documents which need to be reformated for page breaks and section break. These are batch files containing hundreds of documents which end with a Page Break followed by a Section Break(Continuous). To process these files, the Page Break/Section Break(Continuous) needs to be replaced with a Section Break(Next Page). Using vba and Word 2003 we have been able to do simple search and replace of the Page Break OR the Section Break(Continuous) but not the Page Break AND the Section Break(Continuous). Also, I can find no code for doing a Replace on t...

Merging multiple worksheets into one
Hi all, I have one workbook with several worksheets, all of which have the same exact layout and similar data. In the same file, I also have what's called a 'Master sheet'. I would like to basically merge all of the data from every worksheet I have into this one Master sheet, creating continuous rows of information. Is this possible in Excel 2003? Thanks for any help you can offer... Joe Hi Joe You can try this http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl <jfiduccia@warburgpincus.com> wrote in message news:0e3e01c4ac9d$a2...

Outlook and XP Keyboard Access
I just had Windows XP installed on my machine and I am having problems with keyboard access in Outlook 2002. I do not use a mouse and I have my inbox set up with the preview pane. Prior to XP I could get to my inbox with CTRL+Shift+i and then tab around the panes (mail list, preview pane and folders). With XP I can not get a selection in any pane without turning off the preview pane and then turning it on again. Which I then have to repeat every time I use the shortcut to get back to the inbox. This is making me very frustrated. Does anyone have a solution? Thanks in advance! It m...

Desktop shortcut
I know there have been several posts about this but can't seem to figure out some of the answers. I have lost, for some reason, the Create a Desktop Short cut from my right click context menu. I tried one thing and all I got was the Desktop icon on my Desktop. I did more searching but can NOT find: "the file *Desktop (create shortcut)* from the Default user folder." I went to my User folder and there is no such item. Am I looking in the wrong area? And while I'm at it, what could I have done to remove it in the first place. Don't want to do that aga...

Worksheet #2
Is there a way to move from one worksheet to another and stay in the same cell? For example, in Worksheet1, you need to input data in cell A5 and A6. Now you need to go to Worksheet2 and enter different information, but still in cell A5 and A6. So no matter where you start in the first Worksheet, can you go to the next worksheet and be in the same cell Thanks for any help. Select all sheets, then select the cell in question, now ungroup the sheets [MAKE SURE YOU DO THIS], and then use CTRL+PGUP or CTRL+PGDOWN to navigate the sheets -- Regards Ken....................... Mic...

finding all link, hyperlinks in a workbook
ile:///\\animal\shared\Accounting\DEBBIE '05-'06\ADESOGAN.xls - '61'!A1 this is an example of one of my links inside one of my workbook. it leads to another page in the same workbook. i have about 26 workbook with about 31 worksheets in each. each workbook is independent of each other, there should be not link leading out of the workbook itself. i think i may have some links leading out and i can't locate them. there are so many links in each workbook. i tried the suggestion of downloading the FINDLINK.xla but it found no links anywhere in the workbook...lol. just t...

Help w/ an outlook rule
I'm trying to create a rule - when I send an email and include my own address in the CC or BCC fields, I want a copy of the email saved in one of my outlook folders. I don't see a way to call out that my email address is in either of those fields. Also, it doesn't seem to catch when I send an email to myself. Any ideas? ...

Startup from keyboard
Hi to you all I have been using m/s XP for the last 5 years with computer set to start at the touch of any key on the keyboard . I recently got a new computer with Vista installed but can not remember how I set computer up to do this. Can anyone jog my memory. Thanks in anticipation. Bob This is the wrong newsgroup. Try the Windows Vista newsgroup. BTW, what does Great Plains or GP or Dynamics have to do with waking a computer up from sleep? ;-) -- Japheth Nolt Microsoft SBF Specialist Landis Computer www.landiscomputer.com 6/19/2007 11:39:30 AM blackbob wrote: > Hi to you all ...

Workplace activities.
There is nowhere to close an activity. If an activity is past the due date it should disappear and not be displayed with the active activites except under the pastdue activity list. This would be very helpful. Thanks, Pat ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pa...