Ctrl + F not working?

  • Follow


Can anyone tell me what the problem might be if sometimes my CTRL + F
doesn't work in Excel? I often have to go via the menu to do a find.

Thanks
John
0
Reply John 12/1/2009 7:44:04 PM

What happens when you try it?  Are you sure you're hitting ctrl-f (not
alt-f???)?

Does it only happen in a particular workbook?

Does it only happen after you've opened a particular workbook?

If it only happens in a particular workbook, you may have a "helpful" macro
that's behaving the way the developer wanted--but not nice in your eyes.

Try closing excel and re-opening in safe mode:

Close excel
windows start button|Run
type:
excel /safe

And open any workbook and hit ctrl-f to test.

If it works, then I'd guess it was a macro.  But you'll have some detective work
to do.

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

Essentially, you'll turn off all the addins/startup workbooks and then open
excel.  And then turn on each addin (closing and reopening) one at a time to
find the culprit. 

John wrote:
> 
> Can anyone tell me what the problem might be if sometimes my CTRL + F
> doesn't work in Excel? I often have to go via the menu to do a find.
> 
> Thanks
> John

-- 

Dave Peterson
0
Reply Dave 12/1/2009 7:51:22 PM

1 Replies
4089 Views

(page loaded in 0.06 seconds)


Reply: