1

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)
  • 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 ? – George Profenza Jul 8 at 17:35
  • try: LEFT ALT + D + E – user0 Jul 8 at 17:39
  • @GeorgeProfenza answer updated – user0 Jul 8 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 ? – George Profenza Jul 8 at 18:23
  • 1
    awesome! thank you so much for taking your time to document both OSX and Windows – George Profenza Jul 8 at 19:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.