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:

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!