Delete a Column or Row: Select the row or column heading(s) you want to remove. The shortcut keys to hide rows & columns in excel are as below. Here are the steps to hide unused rows and columns: #1 select the row header A6 to select the entire row. Select a cell, click on the lower right corner and drag over the cells you need to fill with the same formula. Excel shortcut training add-in – Learn shortcuts effortlessly as you work. Step 2: Press the shortcut keyboards of Ctrl + Shift + Down Arrow, and then you select all rows beneath the working area. Tom wonders if Microsoft changed one shortcut but not the other. Then click the More icon and select Hide Column.
Shortcut to hide columns in excel Hit Ctrl+V to paste.
