They show you the cells that come AFTER the cell you have selected and our dependent on the data from the cell you have selected. In Excel 2016, there are two different types of tracer arrows.ĭependent tracer arrows show you which cells are dependent upon the value in the cell you have selected.

Tracer arrows show you how data in one cell is connected to data on other cells. Tracer arrows allow you to trace problems in a worksheet. If there are errors in formulas or things are not working as they should within your worksheet, tracer arrows can help you find the problem. They do so by helping you trace 'the path' of your data.

If you have a lot of data contained in your worksheets and workbooks, it can be a chore to go back and isolate each error, then take steps to fix it. Finding and fixing errors could wind up being just as time consuming as entering and calculating the data. At least, it would be if Excel 2016 did not offer you the tools you need to help you efficiently audit and troubleshoot your workbooks and data. With all the functions and formulas Excel 2016 allows you to use in worksheets and workbooks, there is little doubt that you are going to have some errors.

Where is tools menu in excel 2016