Excel Forum

Excel Magic Trick # 3: AVERAGE & Go To Blanks

Excel! Learn how to use the Ctrl + Enter keyboard Trick to enter formulas or data into many cells simultaneously. Also, learn how the AVERAGE function ignores Blanks, but not zeroes! And finally, learn about the amazing GoTo feature to select all Blanks in a range!

Got a Question? Ask it Here in the Forum.