Thursday, October 13, 2022

Excel Hints

 Auto adjust cells to fit data

cntl + a then while holding alt type hoi


Average and ignore zero cells:
=AVERAGEIF(B7:M7,"<>0")

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Pin Not Available

Crazy Error I had not seen before. Pin not available blah blah. I restarted a few times and it finally worked. If it doesn't some say to...