Sort Columns Title For Free

Click the worksheet to which you want to add specific header or footer elements. 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 footer text box at the top or the bottom of the worksheet page.

Click the ?Data? tab and locate the ?Sort & Filter? section. Click the ?Filter? button. Note that each header will have a small drop down arrow to the right of the cell. Click the top of a column that you want to sort and use the appropriate ?Sort? buttons from the Sort & Filter section.

Select the option "Sort left to right" from the "Options" dropdown list. Select the checkbox for "My data has headers." Select the checkbox for "Expand the selection." Click OK to sort your data and automatically group rows.

To sort data in Excel, select all of the cells that you want to sort. Then, go to the Data tab and click on Sort. In the Sort dialog box, make sure that your header row is selected as the Column to sort by. Then choose how you want to sort your data and click OK.

Here are five steps for creating a header row by formatting your spreadsheet as a table: Highlight the data in your spreadsheet. ... Choose the "Home" tab and click "Format as Table" ... Customize the style of your table. ... Confirm the range for your data set. ... Check the "My table has headers" box.

Click the ?Data? tab and locate the ?Sort & Filter? section. Click the ?Filter? button. Note that each header will have a small drop down arrow to the right of the cell. Click the top of a column that you want to sort and use the appropriate ?Sort? buttons from the Sort & Filter section.

Select a column, and then select Transform > Rename. You can also double-click the column header. Enter the new name.