This tip is from Michelle Rosenberg, for Oshkosh ILL staff. But, I thought it would apply for others as well.AutoFilter allows you to easily sort all field of your spreadsheet.Highlight the header row:From the menu choose Data, then Filter, then click AutoFilter.You will now see arrows in the right of each of the column headersClicking on the arrow gives you the ability to sort in ascending or descending order based on the information in that column.
If you wish to set up alternating row colors in Excel, first highlight the rows that you wish to apply the formatting to. In this example, I've selected all rows in the spreadsheet.
Under the Format menu, select Conditional Formatting.
