Excel Shortcut - Ctrl+T Tables Expand

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.