Excel documents can often be a bit confusing. Especially when a three-digit number is used in rows or columns. This is why the "Find" or "Find and replace" functions are particularly useful. We'll show you the associated shortcuts.
Excel: Find
The Find function is a little different from the Find and Replace function. It is simpler and leads you to the search term you want. You can open the search window with the key combination [Ctrl] + [F] . Now enter your search term and press [Enter] or click on " Find next ".
Excel: Find and Replace
The " Find and Replace " function can be used to directly replace the word or number you are looking for with other characters. Open the appropriate window with [Ctrl] + [H] . Enter your search term and the replacement word. With a click on " Replace ", each search word is replaced individually by the new word. If you click on " Find next ", only your search term will be displayed in the document..