Arrange Columns Title For Free

Press and hold the Shift key, and then drag the column to a new location. You will see a faint "I" bar along the entire length of the column and a box indicating where the new column will be moved. That's it! Release the mouse button, then leave the Shift key and find the column moved to a new position.

Sorting levelsSelect a cell in the column you want to sort by.Click the Data tab, then select the Sort command.The Sort dialog box will appear.Click Add Level to add another column to sort by.Select the next column you want to sort by, then click OK.The worksheet will be sorted according to the selected order.

Follow these steps to sort in Excel Desktop:In a PivotTable, click the small arrow next to Row Labels and Column Labels cells.Click a field in the row or column you want to sort.Click the arrow.To sort data in ascending or descending order, click Sort A to Z or Sort Z to A.

Adding column name to the DataFrame : We can add columns to an existing DataFrame using its columns attribute. Output : Now the DataFrame has column names. Renaming column name of a DataFrame : We can rename the columns of a DataFrame by using the rename() function.

Click the worksheet where you want to add or change a built-in header or footer. On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. Click the left, center, or right header or the footer text box at the top or the bottom of the worksheet page.

Press and hold the Shift key, and then drag the column to a new location. You will see a faint "I" bar along the entire length of the column and a box indicating where the new column will be moved. That's it! Release the mouse button, then leave the Shift key and find the column moved to a new position.

Press Ctrl+A to select the current region, including the two header rows. On the Data tab, select Sort. Click the Options button. Select the Sort Left to Right option.