Copy Values From Excel

On this page, you will learn how to copy values from Excel and paste them into the visual.

The visual allows you to copy values from Excel and paste them directly into the leaf cells, providing flexibility in data entry. It's important to note that pasting values into total cells is not supported; attempting to do so will prompt a popup indicating that this action cannot be performed. This limitation exists because the visual performs real-time calculations for total cells so the total cells are calculated by the visual.

Below are the step-by-step instructions along with a demonstration in an image:

1. Select the values in Excel and copy them (Ctrl + C).
2. Navigate to the visual and select the leaf cell where you want to paste the values.
3. Press (Ctrl + V) to paste the values into the visual. You will observe that the values are now populated in the visual, and the totals have been automatically recalculated.

This method allows seamless transfer of data from Excel to the visual, enhancing usability and efficiency in data management.