How do I quickly format multiple data in Excel?

How do I quickly format multiple data in Excel?

In Excel processing data we often need to set a variety of data formats, for the appearance of the table we often need to adjust the format to the same, then if we set the words is very cumbersome, we would like to quickly set the one-time, So how do you quickly set the same formatting for multiple data in Excel? Next I will introduce to you.

Software Name:

EXCEL2007 Green Edition Lite free [58MB]

Software size:

Kb

Update Time:

2013-07-23

Method/Step

1. First, we open the Excel table that needs to be edited.

2, then, select the Start menu in the menu bar. Click the Start menu and select Find and Replace in the tab.

3. Click "Replace" to open the Find and Replace dialog box.

4, click "Options", open the replacement option

5, click "Format", select the format in the cell

6, and then arbitrarily select a cell to change the format

7, and then set the format in "Replace with". Click OK so we are done with the replacement.

The above is how to quickly in Excel for many data sets the same format method introduction, hope to be helpful to everyone!