Why when I try to use Ctrl+F shortcut for Find, do I end up with 20odd rows highlighted? If I use Edit, Find I get the Find dialogue box? It doesn't happen all the time. (Sorry to ask really a dumb question but I can't for the life of me figure out why)
I use Mac and when I hit command F Excel brings up a window that helps you find things on the spreadsheet. I assume that a PC is supposed to have the same function. Is that the function that comes hp when you ht Ctrl+F?
kim, it often happens that macro shortcut keys override Excel's built-in shortcut keys or at least mess with them. So this maybe the root of your problem. Do you have this with any file? You may want to open the concerning file and click on tools on the menubar, then Macro, then Macros. Click on the first one on the list, then options. If it doesn't have f as the shortcut key, cancel and try the next one in the list until you find one with f as the shortcut key. Then delete the f from the box or replace it with another key. Hope this helps.