• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer

Computer Notes

Library
    • Computer Fundamental
    • Computer Memory
    • DBMS Tutorial
    • Operating System
    • Computer Networking
    • C Programming
    • C++ Programming
    • Java Programming
    • C# Programming
    • SQL Tutorial
    • Management Tutorial
    • Computer Graphics
    • Compiler Design
    • Style Sheet
    • JavaScript Tutorial
    • Html Tutorial
    • Wordpress Tutorial
    • Python Tutorial
    • PHP Tutorial
    • JSP Tutorial
    • AngularJS Tutorial
    • Data Structures
    • E Commerce Tutorial
    • Visual Basic
    • Structs2 Tutorial
    • Digital Electronics
    • Internet Terms
    • Servlet Tutorial
    • Software Engineering
    • Interviews Questions
    • Basic Terms
    • Troubleshooting
Menu

Header Right

Home » Excel » Find & Replace in Excel 2010
Next →
← Prev

Find & Replace in Excel 2010

By Dinesh Thakur

When we handle a significant amount of data, sometimes we need to locate specific data in the book. To facilitate this task, there is a search tool. We will find it in the tab Home > Search and select.

To access the Find & Replace, Choose Home >> Find & Select >> Find, or press Control + F Key. See the illustration below.

Home Tab Find & Replace

After clicking the Find Next Button. We will go from one cell to another, among those that contain the entered value. It will search from where we are located, so we must place ourselves in the first cell to search the entire sheet. Also, if we have multiple cells selected, it will only search for them.

Find Tab in Find & Replace

We can also press Search all to show in the window itself a list with the location of each of the cells in which the data is found. The list of results will be a set of links, and simply clicking on one of them will place us in the cell in question.

The Options button allows us to expand the search window with extra options. We can choose where to search (if on the sheet we are on or in the entire book) if we only search for cells with a specific format (for example, only cells with currency format).

Option Button in Find & Replace

We can substitute the data in the Replace tab from the same window or the option Replace Button Search and select (keys CTRL + H), changing one original value for another. The replacement option is not limited to values only. It can also refer to formats. For example, we could find all cells that contain the value 0 in currency format and replace it with the same value but with a red cell colour to highlight them.

Replace Tab in Find & ReplaceExploring Options

Let’s take a look at the different choices available in the Find dialog box.

  • Within: The search should be defined in a Sheet or Workbook.
  • Search By: The internal search method may be defined by rows or columns.
  • Look In: Select this option if you want to find text in the formula as well.
  • Match Case: Choose this option if you want to match the case of terms, such as lower case or upper case.
  • Match Entire Cell Content: Choose this option if you want an exact match between the word and the cell.

You’ll also like:

  1. Working with Excel 2010
  2. Excel 2010 Components
  3. BackStage View in Excel 2010
  4. Managing Data in Excel in 2010
  5. Rows & Columns in Excel 2010
Next →
← Prev
Like/Subscribe us for latest updates     

About Dinesh Thakur
Dinesh ThakurDinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps.

Dinesh Thakur is a Freelance Writer who helps different clients from all over the globe. Dinesh has written over 500+ blogs, 30+ eBooks, and 10000+ Posts for all types of clients.


For any type of query or something that you think is missing, please feel free to Contact us.


Primary Sidebar

Excel 2010

Excel 2010 Tutorials

  • Excel - Started
  • Excel - Tour
  • Excel - BackStage View
  • Excel - Entering Values
  • Excel - Navigating Workbook
  • Excel - Save Workbook
  • Excel - Open/Close Worksheet
  • Excel - Managing Worksheet
  • Excel - Managing Data
  • Excel - Rows & Columns
  • Excel - Copy & Paste
  • Excel - Find & Replace
  • Excel - Spell Checker
  • Excel - Zoom In/Out
  • Excel - Paginated View
  • Excel - Insert Comments
  • Excel - Insert Text Box
  • Excel - Undo/Redo
  • Excel - Formatting Cells
  • Excel - Formatting Worksheets
  • Excel - Working with Formula
  • Excel - Quick Access Toolbar
  • Excel - Name Field
  • Excel - Formula Bar
  • Excel - Status Bar
  • Excel - Full Screen Mode
  • Excel - Grid and Indexing Fields
  • Excel - Preferences Window
  • Excel - Color Scheme

Ribbon Tab

  • Excel - Ribbon Tabs
  • Excel - Show and Hide Ribbon
  • Excel - Adding Ribbon Groups
  • Excel - Active Label of Ribbon Group
  • Excel - Customizing the Ribbon
  • Excel - Contextual Ribbon Tabs

Other Links

  • Excel - PDF Version

Footer

Basic Course

  • Computer Fundamental
  • Computer Networking
  • Operating System
  • Database System
  • Computer Graphics
  • Management System
  • Software Engineering
  • Digital Electronics
  • Electronic Commerce
  • Compiler Design
  • Troubleshooting

Programming

  • Java Programming
  • Structured Query (SQL)
  • C Programming
  • C++ Programming
  • Visual Basic
  • Data Structures
  • Struts 2
  • Java Servlet
  • C# Programming
  • Basic Terms
  • Interviews

World Wide Web

  • Internet
  • Java Script
  • HTML Language
  • Cascading Style Sheet
  • Java Server Pages
  • Wordpress
  • PHP
  • Python Tutorial
  • AngularJS
  • Troubleshooting

 About Us |  Contact Us |  FAQ

Dinesh Thakur is a Technology Columinist and founder of Computer Notes.

Copyright © 2023. All Rights Reserved.