Excel – Count the Number of Blank or Non-Blank Cells

The other day I needed to count the number non-empty cells in a range.  I thought I was going to have to write some complex formula.  Turns out Excel has a nice function to do just this – COUNTA. COUNTA(A5:Z5) for example, would count all of the non-blank cells in Row 5 from Columns A through Z. As you might …

Boost Your Typing and Productivity with Text Expansion

by Kris Traughber Text expansion is the ability to type shortcuts on your keyboard and have them automatically expand to much longer text if desired. For instance, you could type “billingemail” and it would expand to “Dear so-and-so, Your bill is ready to view. Please pay me by ….” Text expansion apps work by running in the background on your …