How to hide a column in Excel The keyboard shortcut to hide a column, a contiguous selection of columns, or a non-contiguous selection is Ctrl + 0. That’s a numeric zero, not an uppercase O.

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.

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 ...

Specficially, Excel inserts rows below and to the right of the selected row or column, respectively. This behavior is in keeping with the fill handle in general.