How do I change multiple cells at the same time?

Account InformationTechRepublic close modalShare with Your FriendsUse Find to edit selected cells in an Excel worksheet all at once Your email has been sent{{#message}}{{{mess

How do I change multiple cells at the same time?

Account InformationTechRepublic close modal

Share with Your Friends

Use Find to edit selected cells in an Excel worksheet all at once

Your email has been sent

{{#message}}{{{message}}}{{/message}}{{^message}}Your submission failed. The server responded with {{status_text}} (code {{status_code}}). Please contact the developer of this form processor to improve this message. Learn More{{/message}}

{{#message}}{{{message}}}{{/message}}{{^message}}It appears your submission was successful. Even though the server responded OK, it is possible the submission was not processed. Please contact the developer of this form processor to improve this message. Learn More{{/message}}

Submitting

Image of maryannrichardson

by maryannrichardson in Software on October 24, 2006, 12:00 AM PDT

Use Find to edit selected cells in an Excel worksheet all at once

Did you know that you can search for and edit multiple cells in Excel? Mary Ann Richardson discusses the Find tool and how you can use it to make big changes in a snap.

Excels Find function makes it easy to search for and edit
multiple cells. The Find dialog box expands to display a list of all the cells
that contain the search criteria in the selected worksheets. You can click an
entry in the list, and it will take you to the cell in the worksheet so you can
edit each cell in the window individually; or, you can use the Find window to
edit all the found cells at once. For example, suppose you copied last years
worksheet and need to change all the cells that contain the text
2005 to 2006. Follow these steps:

  1. Select
    the worksheet containing the text you want to replace.
  2. Press
    [Ctrl]F.
  3. In
    the Find What text box, type 2005.
  4. Click
    the Find All button.
  5. Click
    on one of the entries listed.
  6. Press
    [Ctrl]A.
  7. Click
    the Replace tab.
  8. Enter
    2005 in the Replace With box.
  9. Click
    the Replace All button.

You can also use the Find feature to make formatting changes
to more than one cell at a time. For example, to change all cells that contain
2006 to the font color of red, follow these steps:

  1. Select
    the worksheet you want to search.
  2. Press
    [Ctrl]F.
  3. In
    the Find What text box, type 2006.
  4. Click
    the Find All button.
  5. Click
    on any one of the entries displayed in the Find window and press [Ctrl]A.
  6. Click
    on the Font color button in the Formatting toolbar and select red.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublics free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.maryannrichardsonPublished: October 24, 2006, 12:00 AM PDT Modified: June 8, 2007, 10:07 AM PDT  See more Software

Video liên quan