Excel doesn't have columns per se, but you can achieve a similar effect by creating multiple worksheets or using conditional formatting. Here are the steps to do the three methods:
Method 1: Create multiple worksheets.
1.Open Excel and click on the View tab.
2.Under the View tab, click the "New Query" button.
3.In the pop-up menu, select Get Data from Other Sources or Get Data from File.
4.Select the data source you want to divide into columns and click the "Edit" button.
5.In the Data Editor, use the Split Columns feature to split the data into left and right columns.
6.After the splitting is complete, you can filter and sort the left and right columns respectively.
Method 2: Use conditional formatting.
1.Open Excel and select the data you want to column.
2.In the Home tab, select Conditional Formatting - New Rule.
3.In the New Formatting Rule window, select the Use Formula to Determine Cells to Format option.
4.Enter the formula in the Format value equals box, for example: =mod(row(),2)=0 (for rows) or =mod(column(),2)=0 (for columns).
5.Set the color or format you want to display and click the "OK" button.
6.Repeat steps 3-5 to set conditional formatting for other cells that need to be columned.
7.When it is done, the cells that meet the criteria will be automatically formatted to achieve the column effect.
Method 3: Use auxiliary columns.
1.In Excel, add a secondary column next to the column of data that needs to be columned.
2.In the secondary column, enter the corresponding column ID, such as "1", "2", "1", "2", and so on.
3.Use the filter function of Excel to filter out the data rows with the auxiliary column "1".
4.Set the filtered rows of data to a format, such as bold font or fill background color.
5.Repeat steps 3-4 to filter out the rows with the secondary column "2" and set them to another format.
6.Delete the auxiliary column, and you can get the column effect.
All three methods can achieve the effect of excel** columns, and the specific method you choose depends on your actual needs and the size of the data.
Demo environment. Hardware model: Huawei MateBook D 15
Software version: Windows 10, Microsoft Office 365
App version: None.