Questions tagged [copy-paste]

For questions relating to the selection, copying and subsequent pasting to transfer data.

Filter by
Sorted by
Tagged with
0
votes
1answer
11 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 ...
0
votes
1answer
32 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 ...
1
vote
1answer
16 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 ...
1
vote
1answer
17 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 ...
1
vote
1answer
14 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 ...
2
votes
1answer
44 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
0
votes
1answer
15 views

Copy Google form and linked sheet preserving existing formulas and formatting?

I am required to copy an existing Google Form, however, the linked results sheet has deep formatting and formula. Apparently, the new form requires a new sheet to be linked to form results. How can ...
0
votes
0answers
15 views

copy/paste formula with reference to another sheet?

Within Google sheets, I have a formula like: =COUNTIFS(foo!H:H,"*"&B14&"*",foo!E:E,"*"&C14&"*") which I want to copy past as: =COUNTIFS(bar!H:H,"*"&B14&"*",bar!E:E,"*"&...
0
votes
1answer
3k 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 ...
0
votes
0answers
239 views

Use Google Script to copy current row and row above onto an archive sheet

I'm looking for a way of modifying the script shown in the answer to the question submitted via the below link Cut/Paste projects from Google Sheet using Script to include the current row (B) and ...
1
vote
1answer
2k 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")...
0
votes
1answer
4k views

Copying Cell Color from Conditional Formatting in Google Sheets

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 ...
2
votes
2answers
4k 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(...
2
votes
0answers
332 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 ...
5
votes
1answer
2k 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 ...
0
votes
1answer
84 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 ...
0
votes
1answer
1k views

Copy and paste information once a day form a Google spreadsheet

I have a Google spreadsheet that is being modified during the day, and need to copy and paste the final information (at 8 pm) in a different tab, each day, pasting the new information under the old ...
0
votes
1answer
343 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 ...
2
votes
1answer
1k 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 ...
3
votes
0answers
544 views

How do I fix copy/paste in Google Documents?

At the beginning of this week, I noticed that I can no longer properly copy and paste into or out of a Google Document. I find that if I highlight more than one paragraph and press Edit / Copy or ctrl ...
0
votes
2answers
2k 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 ...
4
votes
2answers
285 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-...
2
votes
0answers
211 views

How to copy multiple files to multiple targets in SkyDrive

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 ...
-1
votes
1answer
4k 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?
1
vote
1answer
1k 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, ...
11
votes
1answer
4k 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.
17
votes
1answer
24k 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
votes
4answers
15k 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 ...
1
vote
1answer
720 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?
1
vote
2answers
75 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....
5
votes
3answers
7k 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 ...