Excel Paste And Skip Blanks Shortcut

Paste & Skip Blanks

This Excel Shortcut pastes and skips blanks.

PC Shorcut:Ctrl+ALT+V>B>Enter
Mac Shorcut:Ctrl++V>+B>Return
Remember This Shortcut:
Ctrl + V is the usual command to Paste. Simply add Alt for Paste Special and use B for Skip Blanks. Alernatively you can use Alt > E > S > B . Remember, Alt is the command to activate the Ribbon shortcuts. E for Paste, S for Special, and B for Skip Blanks.