How to Set Up a Totaling Spreadsheet in Excel. Understanding how cells behave in relation to one another is essential to getting the most out of Microsoft Excel. When you're working with multiple ...

Can Excel sort by color? Absolutely. In addition to sorting by values, Excel can sort by cell color, font color, and cell icon. First, you must you must define the colors for your sort columns/fields.