Google Sheets – Format Clipboard Text as Data Row

copy/pasteformattinggoogle sheetskeyboard shortcuts

I've noticed copying text with a link preserves the link when pasted in Google Sheets. I've also tried copying an inline list from an HTML page and noticed it gets copied as two rows.

Is it possible to format text such that it gets pasted as a single row and two columns in Google Sheets? If so, how?

(I have control of the text being copied and I can use a bit of GApps JS)

Best Answer

Most likely you are looking for direct transposed paste which is supported in Google Sheets via keyboard shortcut combo:

  • LEFT ALT + E + S + E (for Windows+Chrome)

  • CONTROL + OPTION + E + S + E (for OSX)

Also can be accessed via Special Paste:

0

You are able to paste CSV data as is into the spreadsheet and go to Data selecting Split text to columns... and even further specifying the delimiter:

0

0

Also, you can simply use keyboard shortcut combo:

  • LEFT ALT + D + E (for Windows+Chrome)
  • CONTROL + OPTION + D + E (for OSX)
Related Topic