Autofit All the Columns/Rows Instantly
If you’ve got a sheet full of truncated cells (with no text wrap) that no one can read, manually clicking column and row headers one by one helps with readability, but could take a while. Instead, do a Ctrl+A to select all then tap Alt+HOI (hit the letters in that order). That will autofit all the columns. Then use Alt+HOA to autofit the rows. Every cell will be instantly readable, even if now you have to hit the scrollbar more to see everything on the sheet. You can also find those commands using Home > Format > Autofit Row Height or AutoFit Column Width.