The clipboard offers copy & cut, and paste functionalities, enabling you to copy & cut cell data from “Inline Table Editing” macro and paste it to the system clipboard. This can be achieved either via shortcut keys or by triggering a copy & cut.
Copy & cut actions allow exporting data from “Inline Table Editing” macro to the system clipboard. The macro copies and cuts data as a text/plain
.
ESC
Deselect a selected column in the view mode by clicking “Esc”.
Paste only works with ctrl+v combination. If you go into the cell with a right click to insert something, the following pop up will appear:
Use the explained shortcut keys to get to success.
Edit > Copy
- copies the content of the last cell in the selected range
Edit > Cut
- cuts the content of the last cell in the selected range
The context includes default items, including copy & cut options.
Copy - as a predefined key copy
Cut - as a predefined key cut
The paste action allows the importing of data from external sources using the user's system clipboard. The macro firstly searches for text/html
in the system clipboard, followed by text/plain
.
CTRL/CMD + V
- paste the content into the last cell in the selected range
Edit > Paste
- paste the content into the last cell in the selected range
Right-clicking in “Inline Table Editing” macro to paste data is limited by browsers for security reasons. Without these measures, various websites could use scripts to steal the data from users’ clipboards. Some companies, like Google, allow you to paste data between their applications, but this is only a workaround and not a solution. If you want to copy data from another page, web application (like Google Sheets) or MS Excel, use a keyboard shortcut instead.