In Excel, F5 opens the Go To dialogue to move to a specific cell. Just type in the cell reference and press Enter.
Pressing Shift + F5 will open the Find dialogue in Excel. Type in what you want to find and press Enter. Or press Control + Tab for the Find and Replace dialogue, where you can type in what you want to find and then Tab to type in what you want to replace it with.
Function Keys F5 in Microsoft Excel
posted in: Shortcut of the Week
0
Leave a Reply