Excel shortcuts

15 Keyboard Shortcuts for hiding and unhiding columns and rows in Excel

If you work with large spreadsheets in Excel, you know how important it is to be able to quickly hide and unhide columns and rows of data. Here are 15 keyboard shortcuts that will help you do just that:

1. Ctrl+0 (zero) � Hides the selected columns.
2. Ctrl+9 � Hides the selected rows.
3. Ctrl+Shift+0 � Unhides the selected columns.
4. Ctrl+Shift+9 � Unhides the selected rows.
5. Ctrl+* (asterisk) � Selects the entire sheet.
6. Shift+Spacebar � Selects the entire row.
7. Ctrl+Spacebar � Selects the entire column.
8. Ctrl+- (minus sign) � Deletes the selected rows.
9. Ctrl++ (plus sign) � Inserts new rows.
10. Shift+F11 � Inserts a new sheet.
11. Ctrl+Page Up � Moves to the previous sheet.
12. Ctrl+Page Down � Moves to the next sheet.
13. Alt+= � Inserts the sum of the selected cells.
14. Alt+� � Inserts the average of the selected cells.
15. Alt+; � Inserts the count of the selected cells.

These keyboard shortcuts will save you a lot of time when working with large spreadsheets in Excel. Give them a try the next time you need to hide or unhide columns and rows of data.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.