[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