ShortcutdrillPaste values only
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
F2:F11 pull values from another sheet with formulas and are selected. Copy them and paste as values into H2:H11.
What this drill teaches
Paste Special with Values drops the formulas and keeps the numbers. It is the standard way to freeze a calculation before sending a sheet out.
A hint if you get stuck
Windows: Ctrl+C, move, Ctrl+Alt+V, V, Enter. Mac: Cmd+C, move, Cmd+Ctrl+V, V, Enter. The drill allows 4 key presses.
Try it now, no account needed
This drill is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this drill