Introduction To MS Excel tutorial
Chapter 1: MS Excel Basics

Chapter 2: Editing Worksheet In Excel

Chapter 3: Formatting Cells

Chapter 4: Formatting Worksheets

Chapter 5: Working With Formulas

Chapter 6: Advanced Operations

How To Use Find & Replace In MS Excel 2010

Find and Replace Dialogue

Go the Home followed by Find & Select and Find or simply press Control + F Key.

MS Excel Tutorial

You can now see the Find and Replace dialogue with more options.

MS Excel Tutorial

Now you can easily replace the found text with new text with the Replace tab.

MS Excel Tutorial

Exploring options

Find dialogue box offers a wide range of options which includes:
Within – It helps in specifying the search should be in sheet or workbook.
Search by – It specifies the internal search method by rows or columns.
Look In – It helps in finding the text in formula.
Match Case – It helps in matching the case like lower case or upper case of words.
Match Entire Cell Content – It helps in getting the exact match of the word within the cell.

MS Excel Tutorial

Tags

You may also like...

Sorry - Comments are closed

Australia

Unknown
Humidity: 65
Wind: 9 km/h
71 F
65 93
25 Mar 2016
63 87
26 Mar 2016

Slideshow