We are in the process of updating the site, so some pages still have the older design.

Highlightable Tables in Excel (EASY)

Download Project Files
Author:

Make a highlightable table in Excel that shows colored cells without any text but that you can still use in formulas and functions to perform calculations.

This allows you to make a nice visual representation of a table of data without sacrificing your ability to use the results in calculations, sorts, and filters in the worksheet.

Download the Project Files

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

Excel Version: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

Question? Ask it in our Excel Forum

Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Create and Manage Tables in Excel
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...
Using Formulas with Tables in Excel
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...
3 Slicer Tricks for Pivot Tables in Excel
Tutorial: 3 ways to better use Slicers for Pivot Tables in Excel. These tips will show you how to a...
Custom Threshold Highlighting Trick in Excel
Tutorial: How to highlight data in Excel based on the number you input into a cell and the comparis...
I don't use Pivot Tables in Excel anymore, I do this instead
Tutorial: In this tutorial, you'll learn how to create Pivot Tables in Excel without the use of act...
5 Best Tips for Tables in Excel (To Make You a Pro!)
Tutorial: Speed up your workday with these 5 great Table Tips for Excel! These tips make it easier ...
Tutorial Details
Excel Version: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course