How Do I Sum Colored Cells in Excel

Excel subtotal formula.

Are you the type of Microsoft Excel user that loves to add a background cell color? The benefit of color cells is that it makes important information stand out. Another useful feature is that it’s easy to act on the colors. In this tutorial, I’ll show you how to sum colored cells in Excel. Best of all, you won’t need to write any VBA code or use the get.cell function.

Learn the Benefits of an Excel Custom List

Creating an Excel custom list from cell range.

One familiar Excel feature users love is auto-filling a series. Some examples include common lists like months, weekdays, or sequential numbers. In this tutorial, I’ll show you how to create a custom list in Excel that provides similar functionality to the built-in lists. And you can use these in any workbook.

Convert Word Docs to Excel

One item I’ve learned from using computers is that there is usually more than one way to solve a problem. This week two people approached me with a similar problem. They were trying to get a simple, but long address list from Microsoft Word into Microsoft Excel. One tried to use macros and the other resorted to cut and paste. In each case, I thought a simpler solution involved Word’s Search and Replace feature. Here’s Part 1 of a two part tutorial.

How to Convert Word List to Excel

Have you ever received data in an inefficient format? Maybe it was a contact list that looked more like mailing labels. In this tutorial, I’ll show how to convert a Microsoft Word list so you can use it with Microsoft Excel.

Excel Macro Editor Basics

Excel macro dialog box.

This Excel tutorial is the follow up to the previous article we did on using Excel’s built-in macro recorder. It will introduce you to the macro editor and layout so you can create or edit your own macros. It’s also a great way to learn how the macros work.

Customize Excel Ribbon for Your Needs

Excel Ribbon Display Options

One issue I run into with this site is software updates. I’ll be updating an article and low and behold, something is missing or changed. Usually, this is a result of software changes. The area that is impacted the most is the Excel Ribbon. In two articles, I noticed I was missing the Forms button and in the other case, the Excel Developer tab. Both issues are easily fixed when you know how to customize the ribbon.