To add a drop down list (instead of having people type – they just pick from a list so no errors). Type a list of the drop down options in a column. Then select the range of cells for the drop down, go to Data tab > Data validation and …

If you are working with an Excel file created by someone else you may not be clear on how the formulas  connect to other cells. Select a cell and in Formula tab > Formula Auditing > Trace Dependents – this will draw a blue line to all the dependent cells (even …

It is possible to filter n Excel by colour. Once the filter is applied click on the filter drop down arrow and select “Filter by Color” ) select the color you need filtered Note that it is best to use primary colors so people can tell the difference

Flash Fill feature is a fantastic new feature in Excel 2013. You just give it an example or two of what you need it to do and it works out the rest for you. If you have first name and last name in one column and you need them in …