2

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)

1

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)
7
  • 1
    Thanks(+1) that looks pretty close. I didn't quite understand how to use the keyboard shortcut. I did find another function that does what I need: Split text to columns (in the paste context menu). Is there a shortcut for that ? Jul 8 '19 at 17:35
  • try: LEFT ALT + D + E
    – user0
    Jul 8 '19 at 17:39
  • @GeorgeProfenza answer updated
    – user0
    Jul 8 '19 at 17:42
  • using LEFT ALT+D+E types ∂´. This is on OSX. Sorry, but I feel I'm missing something simple with the shortcut notion. Is it hold LEFT ALT then type D, then E (with left alt pressed), press then release each key ? Jul 8 '19 at 18:23
  • 1
    awesome! thank you so much for taking your time to document both OSX and Windows Jul 8 '19 at 19:56

This site is temporarily in read only mode and not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .