Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Some Feature to Share (Excel 2003)

    <P ID="edit" class=small>(Edited by franciz on 23-Dec-08 02:38. wanna to know the feedback of this)</P>I was recently asked if there is there a way or in Excel a feature to bring focus back to worksheet
    without using the mouse from the Find / Replace dialog box?

    I have explore and have discovered that by pressing the Alt and F6 key together while in the dialog box
    will do this. From there, you can do your stuffs and pressing the same or Ctrl and F will bring you back to the
    Find / Replace dialog box.
    However, its does not work with other dialog box and I have no answer to that.
    Maybe some one will provide an answer to this <img src=/S/angel.gif border=0 alt=angel width=15 height=21>

    Let me know what you think about this

    Merry X'mas. Woody Loungers

    cheers, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Some Feature to Share (Excel 2003)

    Most dialogs in Excel are modal, i.e. the user must close the dialog before being able to work with cells again.
    The Find and Replace dialogs are the only modeless dialogs, as far as I know (where the user can work with cells while the dialog remains open). One can click in a cell to select it. Alt+F6 not only switches from the dialog to the worksheet, but also back from the worksheet to the dialog.

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Some Feature to Share (Excel 2003)

    Further to Hans' post; I have found that the Esc key returns focus to the Excel application from all dialog boxes that i have come across. Subsequently entering Ctrl+F will display the Find dialog box complete with the "Find" text that was previously input by the user.
    Regards
    Don

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Some Feature to Share (Excel 2003)

    I noticed that the Alt+F6 key does not work in Excel 2007. I tried many other combinations without success too. Not too sure if there is a combination to get back.

    PS: Don, escape is the global key to escape out of any dialog for any application. If I do this in 2007, then it escapes to the application, but still retains the previous find entry.
    Regards,
    Rudi

  5. #5
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Some Feature to Share (Excel 2003)

    Hi Don

    Esc key is different from what I want to share or discovered. It's does bring the focus back to the worksheet but
    not having the dialog box visable..... although not so much of a different.

    cheers, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •