Surely I can’t be the only one who didn’t know about this keyboard shortcut… or can I? :/ It also works in Word and PowerPoint (probably all Office 2016 apps for the mac). I thought I would post this keyboard shortcut here as it isn’t actually listed in the official Excel Mac 2016 keyboard shortcuts guide but it isn’t intuitive and it took me ages to eventually figure it out.
Excel, Word or PowerPoint simply hold down ‘ctrl’ key and scroll up or down using your mouse or trackpad.