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.

I've used your site for years but just thought that perhaps you might welcome hearing how I return to yours time and time again as my first choice when I'm either learning a new Excel function, or refreshing my memory. I continue to be impressed by every aspect of your site and how user-friendly it is -- from the size and choice of font, to the page organization, to the speed and clarity of the videos, and of course to the organization and clarity of the explanations. -Anna

Calculate worksheets

Related videos

Download 200+ Excel Shortcuts

Excel video training