Excel shortcuts

Top 5 Excel Shortcuts for Creating Tables

If you work with data in Excel, you know how important it is to be able to organize that data into tables. Not only do tables make your data look more presentable, but they also make it easier to work with. If you're looking for ways to make your data entry go faster, here are the top 5 Excel shortcuts for creating tables:

  1. To create a table from a range of cells, select the cells you want to include in the table, then press Ctrl+T. Excel will automatically detect the range of cells you've selected and create a table with those cells.
  2. To add more rows or columns to an existing table, select a cell in the table, then press Ctrl+Shift++ (plus sign). This shortcut will add a new row above the selected cell, or a new column to the left of the selected cell.
  3. To delete a row or column from a table, select the row or column you want to delete, then press Ctrl+- (minus sign). This shortcut will delete the selected row or column from the table.
  4. To quickly fill in the data in your table, select the cells you want to fill, then press Ctrl+D. This shortcut will fill in the selected cells with the data from the cell above. This is a great shortcut for quickly filling in data that follows a similar pattern.
  5. To apply or remove table formatting, select the cells you want to format, then press Ctrl+Shift+T. This shortcut will apply the default table formatting to the selected cells, or remove table formatting from the selected cells.

These are just a few of the many shortcuts you can use to speed up your data entry in Excel. For a more complete list of shortcuts, check out the Excel Keyboard Shortcuts and Function Keys page on Microsoft's support website.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.