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

ShareX My Favorite Snipping Tool

I may want to say something about it. Nothing replaces it. Text Extraction No default hotkey is set up. Go to the hotkey section and add OCR...