[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