Find and Replace Text Occasionally, you'll have a word or number you need to find somewhere in your spreadsheet, but you're not sure where it is. Excel’s find and replace commands scan a worksheet for labels and values with just a few clicks of the mouse. Finding Text Click the Find & Select button on the Home tab. Select Find. Shortcut: Press Ctrl + F. Type the text you want to find in the Find what box. Click Find Next. The first instance is selected. Click Find Next again to move on to other occurrences. Tip: Click Find All to find the cell location of all instances of at once. Click Close when you’re finished.
Find and Replace Text Occasionally, you'll have a word or number you need to find somewhere in your spreadsheet, but you're not sure where it is. Excel’s find and replace commands scan a worksheet for labels and values with just a few clicks of the mouse. Finding Text Click the Find & Select button on the Home tab. Select Find. Shortcut: Press Ctrl + F. Type the text you want to find in the Find what box. Click Find Next. The first instance is selected. Click Find Next again to move on to other occurrences. Tip: Click Find All to find the cell location of all instances of at once. Click Close when you’re finished.
Excel-2016-pt1.docx