July 2008 - Posts

Excel Tip #3: Worksheet Tab Color
17 July 08 11:11 PM | donovani | 0 Comments   

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 Read More...

Filed under: Excel

Excel Tip #2: Identifying Precedent and Dependent Cells, Method 2
07 July 08 01:16 PM | donovani | 1 Comments   

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 Read More...

Filed under: Excel

Excel Tip #1: Identifying Precedent and Dependent Cells, Method 1
07 July 08 01:14 PM | donovani | 1 Comments   

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 Read More...

Filed under: Excel