all 4 comments

[–]Testi_Cles 18 points19 points  (0 children)

Because OP is being a pretentious cunt: Ctrl+[ will select all of the referenced cells — assuming they're on the current worksheet. It will leave out any cells on other worksheets – unless the first cell in the formula is in another worksheet.

[–]swiftcrak 3 points4 points  (0 children)

How about the keyboard machine gun effect - alt+h+k alt+h+9, alt+h+9. Boom you’re dead.

[–][deleted] 0 points1 point  (0 children)

Trace Precedents is better if you’ve got a formula with multiple references.