Format your data as an Excel™ Table before you ask an AI about it
A range that looks like a table is not necessarily one. Excel™ only knows where your data starts and ends if you tell it. A proper Table gives each column one header and a defined edge, which may help any tool that reads the sheet, and it makes your own formulas easier to read.
Clear the way first
A Table needs a clean block. Before converting:
- Unmerge any merged cells in the data.
- Remove blank rows and columns inside the block.
- Move title and banner rows above the header out of the way, so the header is the first row.
- Take total and subtotal rows out of the data. A Table can show its own total row.
- Give every column a unique header. Blank or duplicate headers break the Table or get renamed.
- Unhide hidden rows and columns you want counted, or decide they should not be there.
Convert the range
These steps apply to Excel™ in Microsoft 365.
- Click any cell in the block.
- Press Ctrl+T, or choose Insert → Table.
- Tick "My table has headers" and press OK.
- Give the Table a plain name on the Table Design tab, such as
Sales, notTable1. - Check Formulas → Calculation Options is Automatic.
Keep one Table per sheet where you can, and name sheets for what they hold.
Do it with a safety net
AI Readiness Scanner and Fixer flags data that is not a real Excel™ Table (STR-06), merged cells (STR-01), banner rows (STR-02), blank rows or columns (STR-03), more than one table (STR-04) and mixed-in totals (STR-05). Fixes are applied one at a time with a preview of what will be written, and Undo is free on every tier. Scanning and explanations are free too; applying fixes is the paid part.
Microsoft, Excel and Microsoft 365 are trademarks of the Microsoft group of companies. AI Readiness Scanner and Fixer is not affiliated with or endorsed by Microsoft.