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 don't think you understand how much your training has changed my life in terms of work efficiency and effectiveness not to mention minimizing my stress, anxiety and enabling me to shine in front of employers. -Veronika
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course