Microsoft Excel has a great sorting feature that works quite well. However, it is possible to use this feature to sort cells based on their color. Multiple colors are supported, and from our testing, ...

Every few months, someone discovers the Google Sheets QUERY function and has the same reaction: why did nobody tell me about this? Here is what it does and why it changes how you work with data.

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.

Excel's basic formulas work fine for simple calculations, but they quickly become cumbersome when you're dealing with complex data analysis. You end up with nested functions that are hard to read, ...

Google has added a number of new features to the mobile version of its Spreadsheet program. The biggest change includes the ability for end users to edit spreadsheets from their mobile phone. Users ...

Filters and slicers help you highlight key data in a spreadsheet by hiding less relevant data. Here’s how to make them work for you in Google Sheets. If you’re building a large spreadsheet in Google ...

Google Drive has been updated with a new Filter Views feature that makes it easier to sort and filter data on view-only spreadsheets. Google Sheets users can now turn on a “temporary filter view” from ...

Microsoft Excel 2007 introduced means of sorting and filtering your data by the color of your cells and their text contents. When you use color to highlight important information, such as cost data ...