Excel Tip #3: Worksheet Tab Color

For workbooks that contain more than one category of worksheet, you can use color to add visual distinction to the worksheet tabs along the bottom of the Excel window.  Right-click on the worksheet tab to bring up the dialog: Your tabs are now colorful:

0

Excel Tip #2: Identifying Precedent and Dependent Cells, Method 2

Excel can help you understand or troubleshoot cell references by identifying the cells dependent upon the selected cell and those that the selected cell depends upon. One way to accomplish this is via the Go To Special dialog.  It can be launched from the Find & Select menu of the Editing group in the Home…

1

Excel Tip #1: Identifying Precedent and Dependent Cells, Method 1

Excel can help you understand or troubleshoot cell references by identifying the cells dependent upon the selected cell and those that the selected cell depends upon. One method for doing this is via the Formula Auditing group in the Formulas tab. Let’s start by creating a simple worksheet:   Select A3 then click the Trace…

1