Exceljet

Quick, clean, and to the point

Calculate worksheets

Windows shortcut

Mac shortcut

FnF9

This shortcut will calculate all worksheets in all open workbooks.

See all shortcuts

Related videos

The videos below demonstrate this shortcut.

Dynamic min and max data labels

In this video, we'll look at how to dynamically highlight high and low values in an Excel chart using data labels.

Shortcuts for formulas

In this lesson, we cover shortcuts you can use when building, editing, or entering formulas.

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.

Dave's blog is my first choice when I'm in high waters with Excel. Reason: the mechanics he patiently unfolds bring visual understanding to a subject which is contorted for me, it's like following a straight line. I like that, because it's effective for me. -Joshua

Calculate worksheets

Related videos

Download 200+ Excel Shortcuts

Excel video training