Prepare Excel File

  • Open Excel and create a data grid.
  • Assign a named range to this grid, such as “Grid1”.

Create a Word Document

  • Open a Word document.
  • Insert a table or specify where you want Excel data to appear.

Embed Named Range

  • In the Word document, type `{{Grid1}}` where you want the Excel data to be inserted.

Adjust Table Settings

  • Use “Has Header” to skip the Excel header row.
  • Apply “Skip Row Count” to omit specific rows.