Questions tagged [copy-paste]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
7 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 ...
-1
votes
0answers
4 views

Copy and paste (special) of the content of “equation” in WORD to dreamweaver [migrated]

An ordinary piece of text (even formatted) in WORD can be copied to dreamweaver without any problem. But those written via "equation" will be totally ignored. What I have done is to double ...
1
vote
0answers
10 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
votes
0answers
209 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 ...
2
votes
2answers
125 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 ...
0
votes
0answers
94 views

Extra spaces added when doing copy-paste in Gmail and Google Calendar

It seems that virtually every time I have to copy-paste text between the same message (or a few messages) in Gmail, using Ctrl+Shift+V. To enforce pasting unformatted text. Because, if I am doing a ...
0
votes
1answer
301 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 ...
1
vote
2answers
57 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" ...
0
votes
0answers
102 views

Zoom chat breaks pasted and copied code

It has taken a while to discover what was going on, but any code pasted in and then copied from zoom chat becomes unusable. It looks fine like regular ASCII but must be some weird Unicode equivalent ...
0
votes
2answers
56 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?
1
vote
1answer
309 views

How do I copy data from multiple Google sheets and paste into master Google sheet while maintaining format?

Each day I paste assignments to employees in each employees respective sheet. These assignments have hyperlinks in portions of the data. At the end of each day I copy their assignments for that day ...
1
vote
1answer
901 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 ...
1
vote
1answer
27 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?
1
vote
1answer
654 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, ...
1
vote
1answer
124 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 ...
-1
votes
2answers
72 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....
2
votes
1answer
78 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 ...
0
votes
1answer
243 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
924 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
605 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
53 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
98 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 ...
4
votes
1answer
2k 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
40 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 ...
1
vote
1answer
5k 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 "...
2
votes
1answer
27k 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 ...
2
votes
1answer
5k 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
vote
1answer
13k 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 ...
3
votes
2answers
8k 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(...
4
votes
1answer
600 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 ...
8
votes
1answer
8k 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
132 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
381 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
2k 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 ...
0
votes
2answers
4k 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
439 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
213 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
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?
1
vote
1answer
3k 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, ...
12
votes
3answers
7k 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.
23
votes
1answer
34k 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 ...
22
votes
5answers
23k 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
826 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
77 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
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 ...