Skip to main content
Share Your Experience: Take the 2024 Developer Survey
11 votes
Accepted

How to use "split text to columns" when pasting in Google Sheets?

I took some test CSV data and pasted it into a Google Sheet. When I opened the clipboard and chose "split text to columns", my data was immediately split. There shouldn't be anything else you need to ...
ale's user avatar
  • 52.7k
10 votes
Accepted

How can I copy all events from one calendar to another?

If the other calendar is shared with you and available in the "Other Calendars" section in Google Calendar, you can save the ICS version of the calendar and import that into your own. To do ...
Anson W Han's user avatar
  • 1,379
6 votes
Accepted

How to "fix" a range so that copy/paste doesn't increment it

Use $ sign to lock range. $H$1
TheMaster's user avatar
  • 3,342
5 votes

Copy Date Value and Paste as actual Date not number

You would use the text function. If you have =today() in A1, you would use =text(A1,"mm/dd/yyyy"). (There are multiple formats for 'mm/dd/yyyy' if that's not the format you want.) Alternatively you ...
mfg's user avatar
  • 533
4 votes

How to copy-paste information from one drawing to another one in draw.io

I was able to do this using the scratchpad feature on the left-side menu. In the 'source' diagram, I dragged the component I wanted to copy into the scratchpad, then I opened the 'target' diagram and ...
pards's user avatar
  • 141
3 votes

What is the best way to paste code into a Trello card?

In 2020, wrapping a code block in ``` (triple backticks) in Trello still drops newlines, etc. I have to add 4 spaces before each line to get it display lines and indentation properly. Thanks @GiH for ...
zhark's user avatar
  • 131
2 votes

Paste hyperlink formulas but replace cell references with the actual values from the referenced cells

I had the same issue and found a solution. Copy the column from your spreadsheet. Paste the column into a Google Docs document (not Google Sheets) without linking. Copy the column from the document ...
user69420's user avatar
2 votes

What is the best way to paste code into a Trello card?

I know that the subject is a bit old, but I found myself faced with this problem. I wrote an userscript if anyone is interested in it. It works with triple backslash with line feed and allows syntax ...
BadDemiurgeException's user avatar
2 votes
Accepted

What is a cut and paste approach to converting a chunk of a google spreadsheet to markdown table?

Actually the answer is trivial: Google webapps has MarkdownTableMaker https://chrome.google.com/webstore/detail/markdowntablemaker/cofkbgfmijanlcdooemafafokhhaeold?hl=en Works reasonably well.
Sherwood Botsford's user avatar
2 votes

Pasting with colours and formatting Google Document

Without a sample from Visual Studio 2013 (in Microsoft Windows 8) to hand, I can't be sure but believe enhancements to Docs since OP was posted have changed the circumstances upon which the question ...
pnuts's user avatar
  • 17.6k
2 votes
Accepted

Where is Excel's Paste Special Operations in Google Sheets?

There is no such thing in Google Sheets. All you have in Google Sheets is this:
user0's user avatar
  • 26.7k
2 votes

Is there a way to add a "Copy to clipboard" button in a Google Doc?

Use Google Apps Script to add a custom menu with your button or an option to open a sidebar/dialog that holds your button. You can even publish your script as an add-on so the button will be ...
Rubén - Volunteer Moderator -'s user avatar
2 votes

How can I copy all events from one calendar to another?

An embedded (or embeddable) calendar will have some possibly very long URL starting with http://www.google.com/calendar/embed? Within the possibly very long URL, you will find one or more parts of the ...
Pietro Battiston's user avatar
2 votes
Accepted

How to format clipboard text as data row in Google Sheets?

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 ...
user0's user avatar
  • 26.7k
2 votes
Accepted

Pasting text without interpreting as formula

You can copy paste the data in a tab free of data in column A. Then in column B1 you can use this : =REGEXREPLACE(formulatext(A1),"=",) Copy the cell for every data you have in column A Copy ...
pjmg's user avatar
  • 2,010
2 votes

Copy/multiply cell contents based on number in another cell

Here is another approach: =ArrayFormula(VLOOKUP(TRANSPOSE(SPLIT(JOIN("",REPT(ROW(A:A)&"@",A:A)),"@",0,1)),{ROW(A:A),B:B},2,FALSE)) How It Works =ArrayFormula(...) ...
Erik Tyler's user avatar
  • 5,048
2 votes
Accepted

Copy/multiply cell contents based on number in another cell

Please use the following =QUERY(ArrayFormula(flatten(IFERROR(SPLIT(REPT(B1:B&"@",A1:A),"@")))),"where Col1<>'' ") How the (undocumented) flatten function work. ...
marikamitsos's user avatar
  • 12.9k
1 vote

How do I paste formulas from a plain text file into a Google Sheet?

I solved my problem. Copy and paste without doing anything special at all works just fine.* The reason that was not working for me initially is that inadvertently the cells I was pasting into had ...
jefolicr's user avatar
1 vote
Accepted

How does Google Spreadsheet preserves formatting in external Copy-Paste?

What you are seeing is most likely a Google Sheets optimization side effect. Google Sheets has its own web clipboard that kicks in when you copy one or more cells in a spreadsheet. To avoid that, use ...
doubleunary's user avatar
  • 14.8k
1 vote

How to copy text in a table cell in Notion?

The easiest solution is to change the way you are pasting. On Windows try pasting as Ctrl + shift + V instead of Ctrl + v -- this should paste the values only.
berget's user avatar
  • 11
1 vote

Google Docs paste, using formatting of destination document

Paste regularly, then select all and press C-\ in order to remove styling. This is different from C-S-v in that it doesn't remove structure (headings, titles, etc).
memeplex's user avatar
  • 131
1 vote

How to copy formulas from one spreadsheet to another?

I know this is a few years after the initial question, but I found a quick(ish) workaround that requires a couple steps outside of google sheets.. I tried the 'Show formulae' method as this was a good ...
Maxo's user avatar
  • 21
1 vote

Create a hyperlink from two columns, one with title and one with links, then retain only the hyperlink without losing the references

setFormula is not available within a custom function. One of the workarounds suggested (by Google) is to use onEdit(e) instead of a custom function. Unbelievably, they don't regard this workaround ...
Tedinoz's user avatar
  • 5,721
1 vote

Google Sheets on PC Copy/paste using "Paste Values" (Crtl+shift+V) appears to work but numbers are not treated as numbers in GRAPHS

Try CTRL + SHIFT + V followed by CTRL + \. This should reset the formatting from whatever back to Automatic. Or use straight this combo: CTRL + SHIFT + V LEFT ALT + O N N
user0's user avatar
  • 26.7k
1 vote

How to prevent cut-and-paste data from changing collapsed grouped cells?

Not really possible to prevent this from happening in Google Sheets, but there are always ways with formulas... =ARRAYFORMULA(REGEXREPLACE(TO_TEXT(COUNTIFS(IFERROR(REGEXREPLACE( REGEXEXTRACT(A1:A, "^...
user0's user avatar
  • 26.7k
1 vote

Copying Cell Color from Conditional Formatting

There does not seem to be one from the Sheets UI. The script editor has the ability to get a cell or cells color irrespective of whether it is conditional formatting or manual, with getBackground() ...
Jared Pinkham's user avatar
1 vote

Copying cells in Google Spreadsheets and pasting into text file adds quotes around each cell

Copy of a Comment by Alexander Taylor Oct 27 '15 at 22:34 : i notice that it only happens when cells contain newlines and possibly other special characters. adding the quotes might be done by the ...
1 vote

How to copy-paste information from one drawing to another one in draw.io

As of 11 November 2020, I have found the following solution. Software used: Diagrams.net 13.7.9 Solution Summary: Using mouse controls to select, copy, from source drawing and paste into new drawing ...
Irenaeus of Analysis's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible