About This Shortcut
This shortcut converts a range to an Excel Table. To use this shortcut, first select the range of data you want to convert.
Note: in Mac Excel 365, you can also use Control + T to convert a range to a table.
Insert table
Related videos
How to randomly assign people to teams
In this video, we'll look at a way to use basic formulas to randomly assign people to teams.
Here we have a list of 36 people.
Let's say we want to randomly assign each person to a team of 4 people so that we have a total of 9 teams with 4 people in each.
I'm going to solve this problem in small …
How to apply a table style
In this video, we'll look at how to apply a table style to a table.
Table styles control the look and feel of an Excel Table.
Tables styles allow you to format an entire table with a single click, and the style is applied continuously to a table as new rows and columns are added.
You can find table …
Excel Table Options
In this video, we'll look at the options available for Excel Tables.
Excel provides four settings for Tables you should be aware of.
The first option controls whether a table range will automatically adjust as data changes.
By default, this option is enabled, since this feature is a key benefit of …
Introduction to structured references
In this video, I'll give a brief introduction to structured references.
A structured reference is a term for using a table name in a formula instead of a normal cell reference.
Structured references are optional, and can be used with formulas both inside or outside an Excel table.
Let's take a look …
How to use Table filters
In this video, we'll look at how filters work in an Excel Table.
When you first create an Excel Table, you'll see filter buttons automatically added to the top of each column.
Each filter is customized to match the contents of the column.
For example, when I click the filter for Color, Excel …
How to plot survey data in a bar chart
In this video, we'll look at how to plot results from a survey question in an Excel bar chart.
Here we have data from a survey we ran recently. We've got around 3900 responses to the question "What version of Excel do you use most?".
Let's plot the data in a chart.
The first step is to build a …
How to filter chart data with a table filter
In this video, we'll look at how to filter larger sets of data in a table with filters applied.
When plotting unsummarized data, the chart filter may not be convenient.
For example, here we have historical stock data for Microsoft covering more than 15 years in more than 100 rows of data. If I …
How to build an area chart
In this video, we'll look at how to make an area chart.
Like line charts, area charts are a good way to show trends over time.
However, when plotting multiple data series, you must pay attention to the order in which the data series are plotted.
Here we have some US census population data for …
How to create zebra stripes with conditional formatting
In this video, we'll look at how to use conditional formatting to shade every other row in a table. This is sometimes called "zebra striping".
In this spreadsheet, we have a table of employees with a small amount of formatting. To get shading on every other row, we could just convert this table to a …
How to calculate and highlight expiration dates
In this video we'll look at how to calculate and highlight expiration dates.
Let's say your company has started a membership program of some kind and your boss just sent you a set of data. She's given you a list of 1,000 people that have renewed a membership in the last year or so, and she's looking …
Author
Dave Bruns
Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
I love getting your emails although I don’t really have a huge need for advanced excel formulas...of all the emails I get every day all day long none of them actually give anything of value but your email actually gives value each time I really appreciate it.
Mike
Get Training
Quick, clean, and to the point training
Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.
View Paid Training & Bundles
