Exceljet

Quick, clean, and to the point

Select entire worksheet

Windows shortcut 
CtrlA
Mac shortcut 
A

This shortcut will select the entire worksheet. The behavior changes on subsequent use If the cursor is inside a region with adjacent, non-empty cells:

  1. First time - will select the region that contains non-empty cells
  2. Second time - will select the entire worksheet

Related videos

Tip: How to do a two-way lookup with INDEX and MATCH
In this video, we use use MATCH to find the position of an item in a table, and we use INDEX to retrieve the value at that position. We work step-by-step so you can see how both functions work.
Tip: Shade groups of rows with conditional formatting
In this video, we'll look at how to use conditional formatting to shade alternating groups of rows. For example, you can use this approach to shade groups of 3 rows, groups of 4 rows, and so on. This can be a nice way to make certain tables easier to read.
I am pleased with your course and find it very easy to follow. Wish I had known long time go. It will improve my excel skill enormously.
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course