Browse by Tags

Tagged Content List
  • Blog Post: Excel Tip #4: Adjust the Width of the Horizontal Scroll Bar

    It’s not obvious unless you are looking for it, but you can change the width of the horizontal scroll bar in Excel.  On the left-hand side of the scroll bar there is an anchor you can use to resize. Can become This can be very useful in a workbook with lots of sheets or for wide sheets where you...
  • Blog Post: 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:
  • Blog Post: 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...
  • Blog Post: 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...
Page 1 of 1 (4 items)