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