Press Alt again to see KeyTips for the options for the selected tab. If you want to show the Formula Bar check the Formula Bar option. The active cell displays the results of its formula while we see the formula itself in the Formula Bar.
Select the range or the worksheet you use press Ctrl G to enable Go To dialog click Special.
The location is returned as the number of characters from the start of within_text. The FIND function will return the location of the first instance of find_text in within_text. Within_text required- the text string that is to be searched within. Next click on Excel Options and move to the Advanced tab.