Go to a named range
An Excel shortcut drill from Shortcutdrill. Solve it with a live sheet in your browser with a limit on key presses, and it is checked the moment you submit.
The task
The input cells C4:C9 are named Inputs. Select the whole named range with the Go To box.
What this drill teaches
Names make Go To faster than addresses and keep working when rows are inserted above the range.
A hint if you get stuck
Windows: F5, type Inputs, Enter. Mac: Fn+F5, type Inputs, Enter. The drill allows 1 key press.
This drill is part of Pro
Pro unlocks all 80 drills, with worked solutions and progress saved to your account. The free drills work without an account.
14-day refund, no questions. Cancel a subscription in one click. Students: 50% off annual with a .edu or .ac email.