How do I...
Turn a list into a table
What to do
- Click any cell in your data.
- Press Ctrl+T.
- Check "My table has headers" and click OK.
Good to know
- Formulas fill down by themselves, and new rows are included automatically.
- Charts and pivot tables based on it pick up new rows too.
The idea in general
It tells Excel that this block of cells belongs together.
What I assumed
- You are using Excel on a computer. Menus can look a little different on a Mac or in a browser.