Copy and Paste Tables from MS Excel in Expert Platform 2.0

Copy and Paste Tables from MS Excel in Expert Platform 2.0

Tables support the ability to copy and paste values from Excel.

  • The following formats will be copied over:
    • Borders
    • Cell Alignment
    • Merged Cells
    • Dollar signs
    • Comma formatting
    • Text formatting (bold, italics, underline)




  • Tables also expand rows and columns to fit pasted content, matching the appropriate number of rows and columns from the Excel array.

  • Copy & paste formulas -

    1. In your excel table, open formulas using Ctrl + ` (backtick)
    2. Select the table and use Ctrl + C
    3. Open the Empty table and click inside any cell and press Ctrl + V