LATEST ARTICLES

Free Excel Dashboard Webinars & Excel and Power BI Dashboard Courses (Enrollment Ends 8/22)

Hi Everybody, I'm excited to share with you a Microsoft Excel MVP, Mynda Treacy's, highly acclaimed Excel Dashboard course.  Note that enrollment ends 8/22.  More details below. - STEVE=TRUE Hurry, Last Chance for Free Dashboard Webinars...

How to easily change chart element selections in Excel 2016 2019 and Office 365

Selecting chart elements changed in Excel 2016 2019 and Office 365. Learn how to easily change chart element selections with this quick tip. The technique you used in...
Fix Error Current Sales Greater than Sales Goal - Thermometer Chart in Excel

How-to Fix Sales Goal Error of Excel Thermometer Chart

How-to Fix Sales Goal Error of Excel Thermometer Chart I have to admit that I messed up and presented a broken solution for the Excel Sales Goal Thermometer Chart. The error was presented in this previous...

Hack Excel Protect Workbook

How-to Hack Excel Protect Workbook Feature When You Forgot the Password

Hack Excel Protect Workbook So you forgot / lost your password and need to update your workbook tabs or structure? Well don't cry, don't complain, we can Hack...

How-to Fix a FRUSTRATINGLY Annoying Excel Scroll Lock Issue

Check out this simple technique if you have pressed the wrong keys on your keyboard and can't stop Excel from scrolling instead of moving cells when you use your arrow keys.   Steve=True



Create Vertical Line Between Columns in Excel with Error Bars

Create a Vertical Line Between Columns in Excel Using Error Bars

Create a Vertical Line Between Columns in Excel Using Error Bars Thanks to Leonid (a super fan) for advising me on another and possibly better technique to create a vertical line between columns in your...

Add Vertical Line Between Columns in Excel Stacked Column Chart

Add Vertical Line Between Columns in Excel Stacked Column Chart In this tutorial, you will learn how to QUICKLY add a vertical line between columns in a stacked column chart to visually separate your graph...

Replace Numbers with Text for Excel Radar Chart Axis Values

Replace Numbers with Text in Excel Radar Chart Axis Values

Replace Numbers with Text in Excel Radar Chart Axis Values This is a cool Excel Trick that I just created based on a user request to change Excel Radar Chart Axis values from numbers to...
Find And Replace from a List of Multiple Emails in Excel without VBA

Find And Replace from a List of Multiple Emails in Excel without VBA

Find And Replace from a List of Multiple Emails in Excel without VBA I had a recent request from a friend who needed to Find and Repace from a list of old emails with new...



New Feature Excel Flash Fill Use it for Quick Data Retrieval and Formatting

Excel Flash Fill Every time a new version of Excel is released there are always new features that are hard to find and learn for those that have been using Excel for a long time.  I...