Exceljet

Quick, clean, and to the point

Add or remove the shadow font style

Windows shortcut

Mac shortcut

⌘⇧W

This shortcut toggles shadow font on and off for the current selection. Mac only.

Mac only, not applicable on Windows.

See all shortcuts

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Topics

Key functions

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Read more.

I was searching around for about 45 minutes, trying to find a simple way to count the number of cells in a range which had any number in them. I saw MANY attemps: VisualBasic, Regular expressions which required a huge overhead of code to load, dizzyingly complicated MOD and STR and LENGTH functions strung together in mind-bending combinations, and then... I found yours. Simple, elegant, and ultimately malleable to other purposes. I copied, pasted, modified, and BAM! I was done and it worked *perfectly*! -Dana

Add or remove the shadow font style

Download 200+ Excel Shortcuts

Excel video training