Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
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)
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:
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:
Also, you can simply use keyboard shortcut combo:
LEFT ALT + D + E (for Windows+Chrome)CONTROL + OPTION + D + E (for OSX)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