MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcut - Ctrl+T Tables Expand

September 08, 2017 - by Bill Jelen

Excel Shortcut - Ctrl+T Tables Expand

Using Ctrl + T to create a Table in Excel. If you have a chart or a pivot table or a VLOOKUP based on a range of data that might expand, using Ctrl + T is a great way to make sure the new rows are included in the chart or pivot table.

Watch Video

Auto-Generated Transcript

  • Learn Excel from MrExcel Podcast
  • episode 2149 we're getting near the end
  • of our series of keyboard shortcut
  • podcasts here so let's say that we have
  • this chart based on this table and the
  • table goes January through April and I
  • know that I'm going to be adding more
  • stuff to this I want to press ctrl T
  • like that alright and that makes it into
  • a table apply some formatting the
  • formatting is not the important part
  • here the important part is my pivot
  • tables my charts and my vlookups will
  • all grow as the table growth all right
  • so let's add a new region south like
  • this South gets added to the chart I
  • type some data ctrl enter and then I add
  • a new month May and I'll type some date
  • over here ctrl enter the chart will
  • automatically update because it's a
  • table great great view of great way to
  • have your charts vlookup and and and
  • pivot tables all automatically grow by
  • using ctrl T or ctrl L actually to
  • format as table

Title Photo: stevepb / Pixabay

Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.