Turns the data around the active cell into an Excel table with filters, banded rows and structured references. In a browser Ctrl+T opens a new tab, so practice it in Excel itself.
Your browser keeps this combination for itself, so we explain it here but can't drill it in the page.
More Workbook shortcuts
- Create a chart on a new sheetF11
- Close ExcelAlt+F4
- Close the workbookCtrl+W
- Open the list of macrosAlt+F8
- Insert a new sheetShift+F11
- Create a new workbookCtrl+N
- Switch to the next open workbookCtrl+Tab
- Open the VBA editorAlt+F11
- Open a workbookCtrl+O
- Save the workbookCtrl+S
- Save as a new fileF12
- Show or hide the ribbonCtrl+F1