Shortcutdrill

Level 6: Navigation in big sheets Drill 41 of 80 Pro

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.

Start with the free drills

More drills in Navigation in big sheets