When Excel prompts you to confirm the conversion, note the header question, and then, click OK. Figure A shows two table objects in the same Excel sheet.

Stop sparring with your spreadsheets! Here's how AI transformed my Excel and Google Sheet skills and powered up my productivity.

However, spilling will not occur within an Excel table. Therefore, you could place the formula (s) outside of the table, or you could convert the Excel table to a range of data by clicking anywhere in ...