Shortcutdrill

Level 7: Alt ribbon sequences Drill 53 of 80 Pro

Paste formats 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

Row 1 is bold with a bottom border and is selected. Copy its formatting onto the Total row 12 without changing the values there.

What this drill teaches

Paste Special with Formats carries styles across without touching contents. Ctrl+Down jumps straight to the Total row.

A hint if you get stuck

Windows: Ctrl+C, Ctrl+Alt+V, T, Enter. Mac: Cmd+C, Cmd+Ctrl+V, T, Enter. The drill allows 3 key presses.

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 Alt ribbon sequences