Basic Sorts To execute a basic descending or ascending sort based on one column, highlight the cells that will be sorted and click the Sort Ascending (A-Z) button or Sort Descending (Z-A) button on the standard toolbar.
To sort by multiple columns, follow these steps:
The Autofill feature allows you to quickly fill cells with repetitive or sequential data such as chronological dates or numbers, and repeated text.
If you want to autofill a column with cells displaying the same number or date you must enter identical data to two adjacent cells in a column. Highlight the two cells and drag the handle of the selection with the mouse.
The Autofill feature can also be used for alternating text or numbers. For example, to make a repeating list of the days of the week, type the seven days into seven adjacent cells in a column. Highlight the seven cells and drag down with the mouse. Autofill can also be used to copy functions. In the example below, column A and column B each contain lists of numbers and column C contains the sums of columns A and B for each row. The function in cell C2 would be "=SUM(A2:B2)". This function can then be copied to the remaining cells of column C by activating cell C2 and dragging the handle down to fill in the remaining cells. The autofill feature will automatically update the row numbers as shown below if the cells are reference relatively.