I Fixed Google Sheets: the alt+h,o,i Solution
π Grab the sheet - https://www.gotsheet.xyz/products/autofit-columns-shortcut π Get 1:1 help: https://www.gotsheet.xyz/products/consulting-call-with-eamonn β Get good at spreadsheets and automations: https://gotsheet.xyz/c/gotsheet-youtube I've been irritated with the lack of alt+h,o,i in Sheets for years. So, I finally built a simple Apps Script project where it's baked in. I walk you through the whole thing in this video - do it yourself easily...it's a great beginner's apps script project. If you want to go the extra mile and support the channel, grab the sheet in the first link above π ββββββββββββββββββββ π° Deals & Tools β’ Convert PDFs and images to Excel - https://lido.app/link/eamonn β’ Connect Google Sheets or Excel directly to your business systems like CRMs, databases, and APIs - https://coefficient.io/?via=eamonn β’ 20% off Beehiiv (3 mo.): https://beehiiv.com/partners/got-sheet?via=eamonn β’ My full tech stack: https://gotsheet.xyz/c/business-tech-stack β’ My recommended gear: https://amzn.to/4l47CyW *Disclosure: affiliate links may earn me a small commission at no cost to you.* ββββββββββββββββββββ π Site: https://eamonncottrell.com π LinkedIn: https://linkedin.com/in/eamonncottrell π¦ X/Twitter: https://twitter.com/EamonnCottrell 00:00:00 - The Problem 00:00:13 - In Excel 00:00:34 - Sheets Shortcuts 00:00:57 - Working Solution 00:01:33 - Apps Script 00:02:34 - Flush - a great apps script helper method 00:03:29 - autoresize a whole range 00:03:47 - what about tables? 00:04:25 - Custom Shortcut 00:04:44 - How to Specify the Keyboard Shortcut 00:07:08 - What if You're on a MAC? 00:07:56 - Apps Script Permissions 00:08:31 - Get the Sheet
Download
1 formatsVideo Formats
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.