ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Ctrl F shortcut in Excel ??? (https://www.excelbanter.com/excel-discussion-misc-queries/123562-ctrl-f-shortcut-excel.html)

Anita

Ctrl F shortcut in Excel ???
 
ctrl F = FIND. I believe I have overwritten this shortcut when
experimenting with macros. Can someone tell me how to get this shortcut
back to working as ctrl F = FIND?


Gary''s Student

Ctrl F shortcut in Excel ???
 
very easy

ALT-F8 then select the macro to which the shortcut is/was assigned
click Options and clear the shortcut field

CNTRL-f should then return to what it was.



--
Gary''s Student


"Anita" wrote:

ctrl F = FIND. I believe I have overwritten this shortcut when
experimenting with macros. Can someone tell me how to get this shortcut
back to working as ctrl F = FIND?



Zone

Ctrl F shortcut in Excel ???
 
Anita, I was hoping you'd get a reply because I've done the same thing
myself. You will have to remove the shortcut key from the macro you
assigned it to because macro shortcut keys override Excel's built-in
shortcut keys. To do this, open the file that's giving trouble and
click on Tools on the menubar, then Macro, then Macros. Click on the
first one on the list, then the Options button. 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. I don't know of an easier way to find the
macro that you assinged f to. James
Anita wrote:
ctrl F = FIND. I believe I have overwritten this shortcut when
experimenting with macros. Can someone tell me how to get this shortcut
back to working as ctrl F = FIND?




All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com