| [Ctrl] [Shift] L | Add / Remove Filter |
| [Ctrl] T | Create a Table |
| [Ctrl] arrow key | Move to the edge of the data region |
| [Ctrl] [Shift] arrow key | Increase the selection of the cells until the edge of the data region |
| [Ctrl] 1 | Format cells dialog box |
| [Alt] = | Auto Sum |
| [Alt] H V V | Paste as values |
| [Ctrl] [Space] | Select entire column |
| [Ctrl] [+] | Insert a new cell/row/column |
Unhide all rows and columns using VBA macro
Alt F11
‘This code will unhide all the rows and columns in the Worksheet
Sub UnhideRowsColumns()
Columns.EntireColumn.Hidden = False
Rows.EntireRow.Hidden = False
End Sub
Alt F8