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

Video 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 CONTROL+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 that my pivot tables, my charts, and my VLOOKUPs will all grow as the table grows. Alright?

So, let's add a new region -- SOUTH -- like this. SOUTH gets added to the chart. I type some data, CONTROL+ENTER, and then I add a new month -- MAY -- and I'll type some date over here. CONROL+ENTER. The chart will automatically update because it's a table.

Great, great way to have your charts, VLOOKUP, and pivot tables all automatically grow by using CONTROL+T, or CONTROL+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.