← ACARA Digital Technologies Years 9–10

Converting a range to a Table (Ctrl+T)

Shortcut that converts a data range into a Table with named columns, filter buttons and automatic growth when new rows are added. Tick 'My table has headers' first.

Part of: ACARA Digital Technologies Years 9–10 — Analysing and Visualising Data — Module 4

Understanding Converting a range to a Table (Ctrl+T) in ACARA Digital Technologies Years 9–10

What it does: The Table Name box lets you replace a default name like Table1 with a meaningful one such as SalesData. Ticking 'My table has headers' makes row 1 become the column names instead of being treated as data. Ctrl+T opens the Create Table box. Ctrl+F opens Find, which searches for text and does not create a Table. Tables expand automatically when you type in the row below. Any formulas and charts that use the Table expand with them. Converting a range to a Table adds filter drop-down arrows to each heading. A pivot chart has to be created separately. Use the Table Name box on the Table Design tab. Giving the Table a clear name makes formulas easier to read.

Common mistakes: The first row holds the column headings, so 'My table has headers' must be ticked. If it is unticked, Excel adds extra Column1, Column2 headings and treats your real headings as data. Cancel closes the Create Table box without changing anything. You must click OK to convert the range into a Table.

Class: _____________________  ·  Name: _____________________  ·  Date: _________

Free printable worksheet with full answer key — or add this module to a class and your students practise it interactively.

🖨 Print worksheet + answer key Add Converting a range to a Table (Ctrl+T) to a class →

This module's key terms are also in a printable crossword (Modules 333–377) and word search (Modules 333–412).

Take this worksheet further — free with Cloodit

Each concept is reinforced from every angle — learned, then applied, then tested.

Learning
Duo
Which shortcut converts a selected data range into a Table in Excel?
Ctrl+TCtrl+F
Matches
Press Ctrl+T without ticking 'My table has headers' when row 1 holds headings
↓
Excel adds its own headings (Column1, Column2) and treats your real headings as a data row. Tick the box first.
Applying
Meanings
Term
Ctrl+T
Meaning
Shortcut that converts a data range into a Table with named columns, filter buttons and automatic growth when new rows are added. Tick 'My table has headers' first.
Practice
=SUMIF(B2:B9,"Tech",D2:D9)
Testing
Gaps
Select A1:D9, then press
Check Answer
Spots
2Press Ctrl+T
3Untick My table has headers

Cloodit turns curriculum-aligned coding content into journeys students work through one biome at a time.

The 'Snow Leopard' badge — Silent Debugger, one of Cloodit's 106 collectible badges
Students earn collectable badges

Over 100 of them, across seven natural biomes.

Study Buddy
Students build a real study resource

Turns their work into revision material ready for Flash Cards and Exam study.

Diamond Dash — one of Cloodit's live, competitive Sprint games
Students lock in with Sprints

Live, competitive practice for the start of the lesson or a teacher-led lesson finisher.

A Cloodit certificate of achievement, ready to personalise and print
Custom printable certificates

Honour your top performers, or encourage a student who's trying hard — ready to print in seconds.

Add to class →

Quick Questions

1. Which shortcut converts a selected data range into a Table in Excel?
A. Ctrl+F
B. Ctrl+T ✓
Ctrl+T opens the Create Table box. Ctrl+F opens Find, which searches for text and does not create a Table.
2. Your data has column headings in row 1. What should you do in the Create Table box?
A. Tick 'My table has headers' ✓
B. Leave 'My table has headers' unticked
Ticking the box tells Excel that row 1 holds the column names. If you leave it unticked, Excel adds a generic row such as Column1 and treats your real headings as data.
3. You add a new row directly under a Table. What happens to the Table?
A. It grows to include the new row ✓
B. It stays the same size and ignores the row
Tables expand automatically when you type in the row below. Any formulas and charts that use the Table expand with them.
4. Which of these does a Table give you automatically?
A. Filter buttons on every column heading ✓
B. A pivot chart added to a new sheet
Converting a range to a Table adds filter drop-down arrows to each heading. A pivot chart has to be created separately.
5. Where do you rename a Table, for example to SalesData?
A. In the Name Box at the top of the Home tab
B. In the Table Name box on the Table Design tab ✓
Use the Table Name box on the Table Design tab. Giving the Table a clear name makes formulas easier to read.

Match the Pairs

Ctrl+T → Converts the selected data range into a Table with named columns and filter buttons
Insert > Table → The menu route that does the same job as Ctrl+T and asks if your table has headers
Name your Table so formulas and charts are easy to read and find → Table Name box: SalesData
Tell Excel the first row holds your column headings before you create the Table → [x] My table has headers
Press Ctrl+T without ticking 'My table has headers' when row 1 holds headings → Excel adds its own headings (Column1, Column2) and treats your real headings as a data row. Tick the box first.
Type a new row two lines below the Table and expect the Table to grow → A Table only grows when the new row is typed directly under its last row, with no blank row gap.

Key Term

Ctrl+T
Shortcut that converts a data range into a Table with named columns, filter buttons and automatic growth when new rows are added. Tick 'My table has headers' first.

Fill in the Blanks

1. Select A1:D9, then press Ctrl+T
Hint: Type the keyboard shortcut that converts a range into a Table.
2. Table name: Marks =SUM(Marks[Maths])
Hint: Type the table name shown in the Name Box, which is used before the column name in square brackets.
3. Tick 'My table has headers' in the dialog
Hint: Type the word for the labels in row 1 that become the Table's column names.
4. Google Sheets: Format > Convert to table
Hint: Type the menu option in Google Sheets that turns a range into a Table.
5. Table name: Marks Mean of Science, updates when rows are added =AVERAGE(Marks[Science])
Hint: Type the function name that finds the mean of a column.

Spot the Error

Question 1
A Click any cell in A1:D9
B Press Ctrl+T
C Untick My table has headers
D Click OK
Line C — The first row holds the column headings, so 'My table has headers' must be ticked. If it is unticked, Excel adds extra Column1, Column2 headings and treats your real headings as data.
Question 2
A Select A1:D9
B Press Ctrl+T
C Tick My table has headers
D Click Cancel to make the Table
Line D — Cancel closes the Create Table box without changing anything. You must click OK to convert the range into a Table.
Question 3
A Click inside the Table
B Open the Page Layout tab
C Type Sales in Table Name
Line B — The Table Name box is on the Table Design tab, which appears when you click inside a Table. Page Layout does not have it.
Question 4
A Table name: Sales
B Column: Amount
C Formula in F1:
D =SUM(Sales(Amount))
Line D — Structured references use square brackets around the column name, so it should be Sales[Amount]. Round brackets are only for the function. This formula grows when new rows are added.
Question 5
A Select the data range
B Format > Wrap text
C Check the column headers
Line B — In Google Sheets the Table is made with Format > Convert to table. Wrap text only changes how long text is displayed and does not create a Table.

Student with a class code? Join your class →