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 -
- In your excel table, open formulas using Ctrl + ` (backtick)
- Select the table and use Ctrl + C
- Open the Empty table and click inside any cell and press Ctrl + V