Oct 19, 2018 - You can sort column data alphabetically or by increasing or decreasing values.

Tip • Use Excel's 'Freeze Panes' functionality to lock rows or columns in place. Use Excel sort features to organize data in alphabetical or numerical order. How to Have Excel Freeze Row and Column Data It's often useful to freeze header rows or columns in Excel while navigating through a spreadsheet.

Otherwise, you may need to repeatedly scroll to the top or left of the sheet to remember what's in what row or column. To do this, use Excel's Freeze Panes function. If you want to freeze just one row, one column or both, click the View tab, then Freeze Panes.

Click either Freeze First Column or Freeze First Row to freeze the appropriate section of your data. If you want to freeze both a row and a column, use both options. If you want to freeze more than just one row or one column, click the cell in the spreadsheet that's just to the right of the last column you want to freeze and just below the last row you want to freeze. Why does excel not work for mac.

Then, click the View tab and Freeze Panes. Click Freeze Panes again within the Freeze Panes menu section. Have Excel Sort Data Excel can sort data in a spreadsheet in alphabetical or numerical order. Often, you'll just want to sort all of the data in a spreadsheet except for the header by the values in a certain column. To do this, use your mouse to click on and select a cell in the column you want to sort.

Then, click the Data tab. Click the AZ button to sort the data in alphabetical order, or in numerical order from smaller numbers to larger ones. Or click the ZA button to sort in the opposite order, so larger numbers and words later in the alphabet come first. Generally Excel will detect if there are headers present and leave those rows frozen.

If you only want to sort a portion of the spreadsheet, select the relevant section, including any headers. Then click the Sort button in the Data tab. Use the drop-downs to select the column or columns to sort by and check the box 'My data has headers' if that applies. Use the Order drop-down menu to choose which order to sort the data in, whether largest to smallest or smallest to largest. Click OK when you are done. You can also use the Sort button for greater customization when you're sorting an entire spreadsheet or if Excel is not detecting your header row for some reason. If data are grouped together by row, you generally will want to sort the entire spreadsheet, or at least each column in a set of rows, so that data remains grouped together rather than having some columns sorted and some not.