The second time you use the shortcut (consecutively), Excel will opt for entire worksheet.

The videos below demonstrate this shortcut.

How to create a dynamic named range with OFFSET

Why pivot tables?

Video thumbnail for How to create a dynamic named range with OFFSET

Video thumbnail for Why pivot tables?

Video thumbnail for Shortcuts for selecting cells

Video thumbnail for Shortcut recipe: fill in missing data

Video thumbnail for How to do a two-way lookup with INDEX and MATCH

Video thumbnail for How to fill in missing data part 2