How to set the same alignment of the contents of multiple columns in excel?

#How to set the same alignment of the contents of multiple columns in excel?

Set the same alignment method for multiple columns in excel:

1. Open an excel file and find the two columns of data that need to be automatically aligned. Here, as needed Two columns are simulated:

2. Click with the left mouse button to select cell C1:

3. Enter the formula =IF(COUNTIF(B$1:B$156,A1)=0,"",A1)

#4 in cell C1. After entering the formula, return Car, select cell C1 again:

##5. Pull down the formula to fill in the length of the A1 data, and fill in the A1 column as long as it is:

6. After the filling is completed, you can see that the same data in columns A1 and C1 corresponds:

Recommended tutorial: "

excel basic tutorial》

The above is the detailed content of How to set the same alignment of the contents of multiple columns in excel?. For more information, please follow other related articles on the PHP Chinese website!