3

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 Answer 1

2

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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