Questions tagged [copy-paste]
For questions relating to the selection, copying and subsequent pasting to transfer data.
50
questions
0
votes
1
answer
1k
views
Creating a dynamic copy of another Google Sheet, in which new columns could always be linked to the dynamic copy
In a dynamic copy of an existing spreadsheet (that is also updated with new lines), I made a dynamic copy in another spreadsheet, in which I added columns. All good here.
I use the new columns to ...
CommunityBot
- 1
0
votes
1
answer
387
views
Extract Data from 2 columns if it matches condition
This is how my main data sheet looks like
And for any item that has customization, for e.g. - ORGANIC, I want to extract/copy just those data, the meal name & total units to another sheet.
And ...
CommunityBot
- 1
0
votes
1
answer
1k
views
Generate "cards" with info in Google Sheets
I have a sheet for an event and I need to generate identification cards like in the image for the pieces on the contest, around 1000 pieces, so no way to manually do it.
I did a similar thing years ...
CommunityBot
- 1
4
votes
2
answers
1k
views
Copy several Slack chat messages without timestamps or users
If I try copying and pasting several Slack chat messages, I usually end up with lots of extra lines that are empty, or have a timestamp, or have a username and a timestamp.
Is there any way to just ...
- 177
3
votes
3
answers
4k
views
Paste hyperlink formulas but replace cell references with the actual values from the referenced cells
Consider the following:
A
B
C
=HYPERLINK(C2, B2)
Google
http://google.com
=HYPERLINK(C3, B3)
Facebook
http://facebook.com
=HYPERLINK(C4, B4)
Uber
http://uber.com
I wish to remove columns B & ...
- 3,403
0
votes
1
answer
240
views
Copy Row Script & Paste at last Row in the Same Sheet
Do you guys have idea in script how can I copy the details on quotation GE-2108-0271-Rev.0 in few pages and paste the row at the bottom in the same sheet?
Page 1: to be exact I need the number ...
CommunityBot
- 1
1
vote
2
answers
3k
views
How to copy formulas from one spreadsheet to another?
If I select say 10 rows in Google Spreadsheets and use ctrl+c and then create a new spreadsheet and try to paste all the data it only moves over the values but not the formulas. Is there any way to ...
- 21
4
votes
4
answers
46k
views
How can I copy all events from one calendar to another?
Normally if you want to copy all Google Calendar events from one calendar to another, you'd export from one and import into the other. However, if the calendar isn't your own, the export feature isn't ...
- 121
1
vote
1
answer
38
views
How to copy and paste a formula changing only the cell references made on this sheet
How can I copy and paste a formula changing only the cell references made on the active sheet and leave references to ranges on another sheet as is?
CommunityBot
- 1
2
votes
2
answers
644
views
A Script that Allows a Checkbox to Recognise a Value via Formula and Copy to Another Cell
Is it possible for:
a set of checkboxes to recognise lists (grouped in one cell) on entry (via formula)
to then have the same checkboxes copy the list to another cell as it returns "TRUE"
...
CommunityBot
- 1
1
vote
2
answers
118
views
How do I paste formulas from a plain text file into a Google Sheet?
When I copy a formula from a text file into a Google Sheet, it shows up as plain text in the sheet rather than being used as a formula.
For example if I copy "=2+3" (not including the quotes)...
- 21
0
votes
0
answers
70
views
Pasting HTML in Google Docs works from a copy of an Alacritty terminal, but not from Linux Terminal or an editor or Google Docs. Why? How?
If you copy and Ctrl+V-paste it from the terminal to Google Docs, you see:
But you cannot do this with the same code once that it was pasted as plain text in an editor or Google Docs. If you for ...
3
votes
1
answer
1k
views
Create a hyperlink from two columns, one with title and one with links, then retain only the hyperlink without losing the references
Demo sheet here.
Say I have two columns, one with string literal names, and one with links (in text form)
A B
Restaurant 1 http://www.link1.com
Restaurant 2 http://www.link2.com
...
CommunityBot
- 1
2
votes
1
answer
18k
views
Copying Cell Color from Conditional Formatting
I have a spreadsheet that currently conditionally formats some cells, changing the background color. I am trying to copy/paste these cells and preserve the color of the background without having to ...
- 44.6k
2
votes
2
answers
8k
views
Copy Date Value and Paste as actual Date not number
I have a Google sheet with a cell (D1) that contains a formula (=TODAY()) to show the current date. I am trying to create a macro that will simply copy the value of D1 as displayed (e.g., "5/18/2018")...
- 1
2
votes
1
answer
243
views
How to prevent cut-and-paste data from changing collapsed grouped cells?
I'm completely lost and don't know how to paste any data without affecting those collapsed rows.
For example, I have such a list:
And I want to paste numbers from 1 to 4 for every capital letter ...
CommunityBot
- 1
1
vote
1
answer
278
views
How does Google Spreadsheet preserves formatting in external Copy-Paste?
Note: This is on MacOS. I don't know if it is repeatable on Windows.
When I copy a cell to a text editor and back, formatting (and links) are preserved. Even links, while don't appear in the text ...
- 113
1
vote
0
answers
55
views
Why 2 columns of the same value give different total?
Sample Data in Result Sheet
I have a formula in A2 that extracts data & splits it into unit & product (A & B).
I used the SUMIF formula to give the the total of each separate set of ...
- 345
0
votes
2
answers
2k
views
How to copy text in a table cell in Notion?
When I select a table cell and copy it, all I have is a list of links. I want to copy text only. Is this possible?
- 11
0
votes
0
answers
303
views
How to copy and paste HTML (including images) from password protected pages?
I want to copy HTML (including images) from a web page to google docs.
This works fine if the web page is public.
But if the page needs a login, then the images are not inserted into google docs.
I ...
- 44.6k
14
votes
4
answers
12k
views
How to copy-paste information from one drawing to another one in draw.io
In Draw.Io is there a way to copy-paste information from one drawing on one tab to another one in a different tab?
I couldn't find a way to do it.
1
vote
0
answers
4k
views
Google slides copy object 'with' its animations
I want to copy some objects with animations to another slide 'with' their animations. But I am not sure how to do that. If I copy the objects (ctrl+c) from one slide and paste them into another slide (...
- 250
1
vote
0
answers
2k
views
Google Docs paste, using formatting of destination document
I want to copy/paste a bunch of content from one Google Doc to another. The two documents have different formatting (particularly fonts for Headings).
If I do a regular paste (ctrl-v), the headings ...
- 509
1
vote
0
answers
88
views
Stop Gmail and Google Calendar from replacing URL's titles
From about 2-3 weeks or so Gmail and Google Calendar (and probably many more) has enabled a "helpful" feature of replacing URL with corresponding webpage's title, when those pasting URL.
Is ...
- 2,650
5
votes
0
answers
1k
views
Facebook: How to successfully paste formatted text into a group post?
On Facebook, when creating a new post to be posted into a Group (as opposed to onto a standard personal or company page), Facebook allows you to add some simple formatting to the post.
If you ...
1
vote
1
answer
10k
views
Is there a way to add a "Copy to clipboard" button in a Google Doc?
I have a Google Doc that has a bunch of templates that I need to copy and then paste somewhere else. I'm wondering if Google Docs has a function that lets me highlight a paragraph then add a "...
- 9,915
-1
votes
2
answers
137
views
How to Paste Rows into Google Sheets from Microsoft Works Database
I use an old program called Microsoft Works Database to maintain lists in the form of spreadsheets. After I update a list, I could copy the information to Google Sheets so that I can view them online....
- 99
2
votes
2
answers
398
views
Copy/multiply cell contents based on number in another cell
I have a list of items, Col. B & numbers in Col. A.
I want to multiply/copy the text in cell B based on the number in their relative cell A. I.e. multiply 'B' by the number of times in 'A'
Here's ...
- 4,980
1
vote
2
answers
3k
views
Paste values +transposed
IS there a way to paste transposed but also just values? I want to paste values only, not formulas, keep the destination format and also transpose the data pasted. Is there a way to do this?
- 152
25
votes
5
answers
30k
views
What is the best way to paste code into a Trello card?
When I try to paste code into Trello I get very weird formatting after saving but it seems it does format code, I just can't get it to work right. Currently I'm just putting links to Gist, but I would ...
- 131
1
vote
1
answer
2k
views
How can I paste HYPERLINK formula in Google Sheets cell, to make it clickable link with defined text?
I got a script that takes some data and prepares it to paste into Google Sheets cells, some of which are supposed to be links with custom text. But when I paste hyperlink formula the script created, ...
- 111
0
votes
1
answer
400
views
Why doesn't my onEdit Function behave the same as my onFormSubmit
With the excellent help of this site I was able to get my onFormSubmit working.
However I need the same thing to happen on another sheet only it has to happen after a cell has been assigned one of two ...
- 12.6k
2
votes
1
answer
375
views
Pasting text without interpreting as formula [duplicate]
I'm trying to copy a table of data from a website into Google Sheets. The table includes a column whose numbers are preceded by +/-, e.g., +/- 33. Excel works just fine, allowing me to paste in the ...
- 1,968
0
votes
1
answer
360
views
Google Sheets on PC Copy/paste using "Paste Values" (Crtl+shift+V) appears to work but numbers are not treated as numbers in GRAPHS
When I copy numbers using either "Edit/Copy" or "Crtl+C" in Google Sheets on PC and then use "Edit/Paste/Special/Paste Values" or (Crtl+shift+V), the numbers are indeed pasted. They appear normal and ...
- 26.2k
3
votes
1
answer
1k
views
How to format clipboard text as data row in Google Sheets?
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 ...
- 26.2k
1
vote
1
answer
104
views
Assert cell style onto text pasted into that cell
I'm not quite sure how to word this so I couldn't find any answers to my question after some searching.
I am trying to copy and paste values into my Google sheet. These values are copied from another ...
- 26.2k
4
votes
1
answer
4k
views
Where is Excel's Paste Special Operations in Google Sheets?
I want to copy a cell with 100 in it, and paste special - multiply, to multiply a range by that 100
- 26.2k
3
votes
2
answers
13k
views
How to "fix" a range so that copy/paste doesn't increment it
When filling this formula down a column:
=if(OR(H5>=LARGE(UNIQUE(H1:H11),1), H5>=LARGE(UNIQUE(H1:H11),2)), "top", "")
When I copy/paste it from row 5 to row 6 I get:
=if(OR(H6>=LARGE(...
1
vote
1
answer
4k
views
Copying cells in Google Spreadsheets and pasting into text file adds quotes around each cell
Copying cells in Google Spreadsheets and pasting into text file (tried with XCode, Notes, Text Edit - the below applies to all) adds quotes around each cell.
How can I avoid those extra quotes? Also, ...
CommunityBot
- 1
2
votes
1
answer
3k
views
Disable Drag & Drop Google Sheets
DEFINING DRAG & DROP:
In google sheets if you have a cell or cells currently selected you can perform an operation on them.
One such option is to move your cursor to the edge of the selection ...
CommunityBot
- 1
0
votes
2
answers
5k
views
Pasting with colours and formatting Google Document
I've copied some sample code from Visual Studio 2013 (in Microsoft Windows 8).
I'm doing ctrl + v to paste into an online Google Document.
The paste loses all the formatting and text.
Is there anyway ...
CommunityBot
- 1
1
vote
2
answers
79
views
Sending commands over Gmail
Sometimes I send (and receive) long command lines to colleagues over Gmail. When the command spans many lines Gmail adds newline character making me unable to copy the command directly to the terminal....
- 17.4k
5
votes
3
answers
8k
views
Gmail Google Chat hard to copy text from chat window [closed]
Using Google Chat in Gmail it is impossible to select all the text in the conversation. I often want to quickly copy the text from one conversation and email it or instant message it to another ...
- 17.4k
30
votes
1
answer
42k
views
In copy/paste, Google Docs says "These actions are unavailable via the Edit menu, but you can still use Ctrl C" etc?
When selecting copy/paste from the right-click menu, why does Google Docs pop up a dialog to say:
Copying and Pasting in Google Docs
with the message:
These actions are unavailable via the Edit ...
- 17.4k
12
votes
1
answer
15k
views
How to use "split text to columns" when pasting in Google Sheets?
I have some CSV data in the clipboard that I'm trying to paste into a Google sheet (Chrome, Windows 7). There isn't really a direct paste option for CSV data (like the "Paste Unformatted Text" option ...
- 52.3k
0
votes
1
answer
167
views
What is a cut and paste approach to converting a chunk of a google spreadsheet to markdown table?
I maintain my web site in a version of markdown, with the common table extension.
I maintain my inventory as a google spreadsheet.
I'd like a quick way to copy paste a chunk of a spreadsheet, and ...
4
votes
2
answers
505
views
Is there a simple way to attribute a CC image on flickr?
To legally reuse a CC image from Flickr, you must attribute properly the source and license, as explained on this blog: http://librarianbyday.net/2009/09/28/how-to-attribute-a-creative-commons-photo-...
CommunityBot
- 1
-1
votes
1
answer
5k
views
How can I copy a Gmail message to the Clipboard? [closed]
I just want to be able to copy all or part of a Gmail message to the Clipboard.
Can I do that?
- 52.3k
2
votes
0
answers
217
views
How to copy multiple files to multiple targets in SkyDrive [closed]
I want to copy a couple of files that I have to each of about 12 different folders, so that each of the folders has a different copy of the file in it.
Currently, I am using the 'Copy to' option in ...
- 121
1
vote
1
answer
944
views
Copying text from Gmail without line-breaks
Sending emails in plain text format with Gmail wraps each line at ~70 characters. How can I copy the text from a received/sent mail without the line-breaks?
CommunityBot
- 1