Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctrl+H for Replace
Excel 2003 - When opening a new session of Excel and I press Ctrl+H it brings
up the Replace dialog box with the cursor blinking in the Find field. When closing the box and pressing Ctrl+H again, the Replace field is now highlighted. Once a new instance of Excel is opened, then pressing the Ctrl+H will place the cursor in the Find field again. Is this the way Excel was designed to work? If so, is there any way to change it so that every time the Replace dialog box is brought up the cursor is in the Find field? -- maryj |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctrl+H for Replace
This is because it stores your previous find and replace (within this
session) for your convenience. As such, your last work is automatically highlighted. The only way to avoid it would be to clear the fields before closing the dialog box. If you're doing loads of find and replace and (as you appear) are a keyboard fan, then whilst you can't change excel's behaviour in this regard, you can work around it - you're probably aware that TAB moves forward a field. If you hold down SHIFT and tap TAB, you'll move back one field. Without miving the mouse, it's probably your best way around this. HTH, Tom. "maryj" wrote: Excel 2003 - When opening a new session of Excel and I press Ctrl+H it brings up the Replace dialog box with the cursor blinking in the Find field. When closing the box and pressing Ctrl+H again, the Replace field is now highlighted. Once a new instance of Excel is opened, then pressing the Ctrl+H will place the cursor in the Find field again. Is this the way Excel was designed to work? If so, is there any way to change it so that every time the Replace dialog box is brought up the cursor is in the Find field? -- maryj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to forbid ctrl+c and ctrl+X in sheet? | Setting up and Configuration of Excel | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
CARET or ^, as in CTRL but CTRL !!! ??? | Excel Worksheet Functions | |||
CTRL-END | Excel Discussion (Misc queries) | |||
How can I use replace(alt+H) for mutiple items needing replace | Excel Worksheet Functions |