This shortcut also works with contiguous and non-contiguous selections. How to apply AutoFit to a column in Excel As you’re probably learning, if you can do it to a row, you can do it to a column.

An curved arrow pointing right. Every Excel expert knows how to navigate without a mouse and how to format data using keyboard shortcuts. But do you know how to insert a sum without typing the ...

These shortcuts are found in both the "Data" and "Home" tabs. Excel automatically tries to alphabetize vertically by column, but you can easily adjust this setting to sort horizontally by row.