Excel Study · Module 2: Entering & formatting data
Class 17Format as Table (Ctrl+T)
Basics1:32 videoFree
Click any cell in your data and press Ctrl+T (Cmd+T on a Mac): Excel turns the range into a table with striped rows and a filter button on every header.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, my data is a table named Table1 with a column called Sales. Write a formula for C9 that adds up the whole Sales column.
The answer that works
✓ checked in Excel=SUM(Table1[Sales])
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.