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

Clear Start Menu Pinned Items

I haven't used this yet but plan to on the next Win 11 implementation. The .bat file to run the .ps1 Paste the following into a notepad ...