I chose to use the middle green format in the Light category. Click for larger image. Excel will auto-detect the perimeter of your table and populate the range. It will also auto-detect headings.

Microsoft is using artificial intelligence to convert photos of data tables into a table in Excel. Users will be able to take photos of hardcopy data and import it straight into a fully editable ...

Microsoft Excel is gaining the ability to insert an image directly into a cell, an oft-requested feature. The rollout is expected to begin in December 2022.