TIPS - Autofit All the Columns/Rows Instantly

Summary

Autofit All the Columns/Rows Instantly

Body

Autofit All the Columns/Rows Instantly

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.

Details

Details

Article ID: 8608
Created
Wed 10/18/23 10:18 AM
Modified
Wed 10/18/23 10:18 AM