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")

at
Labels:

ShareX Set To Irfanview

I like ShareX to open a snip with IrfanView. Sometimes when updating, I lose that setting. This is one way to restore it. What likely change...