Note: in Mac Excel 365, you can also use Control + T to convert a range to a table.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Excel Shortcut Insert table - 21Excel Shortcut Insert table - 83Excel Shortcut Insert table - 67Excel Shortcut Insert table - 75Excel Shortcut Insert table - 55Excel Shortcut Insert table - 93Excel Shortcut Insert table - 41