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
0 answers
22 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 ...
user avatar
  • 149
0 votes
0 answers
14 views

How to make a script through matching data and paste values to specified fields?

First I would like to point out the fact that I'm nowhere near to the level of a professional programmer. I'm only in the phase of learning and doing it as a hobby. I'm trying to create a script in ...
user avatar
0 votes
0 answers
89 views

How to permanently format column as plain text in Google Sheets?

I have a google sheet that reformats a csv. The desired functionality is the user pastes the csv contents into the sheet as plain text, and it is automatically formatted in a separate tab. I have all ...
user avatar
  • 1
0 votes
1 answer
38 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?
user avatar
  • 740
0 votes
0 answers
32 views

How to keep formatting with the column/ cell rather than cut when cutting and pasting data?

I work for a small mortgage company and we keep a Google spreadsheet active at all times with each officer’s open loans so that everyone has access to loan numbers and we can all keep track of where ...
user avatar
0 votes
1 answer
44 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 ...
user avatar
  • 145
1 vote
0 answers
826 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 (...
user avatar
0 votes
1 answer
31 views

Google Sheets Script - Duplicate inactive sheet and Rename based in active cell data

I have a working sheet, "Booking Form". I have a template of the working sheet, "Exported". What I would like to do in this function is; duplicate template sheet "Exported&...
user avatar
0 votes
1 answer
62 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 ...
user avatar
  • 1
1 vote
0 answers
44 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 ...
user avatar
  • 509
1 vote
0 answers
21 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 ...
user avatar
  • 2,486
3 votes
0 answers
608 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 ...
user avatar
2 votes
2 answers
140 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 ...
user avatar
  • 145
0 votes
1 answer
611 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 ...
user avatar
  • 1
1 vote
2 answers
268 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" ...
user avatar
  • 13
1 vote
2 answers
761 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?
user avatar
1 vote
1 answer
378 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 ...
user avatar
1 vote
1 answer
2k 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 ...
user avatar
1 vote
1 answer
29 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?
user avatar
1 vote
1 answer
1k 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, ...
user avatar
1 vote
1 answer
280 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 ...
user avatar
-1 votes
2 answers
113 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....
user avatar
  • 99
2 votes
1 answer
128 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 ...
user avatar
0 votes
1 answer
268 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 ...
user avatar
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 ...
user avatar
2 votes
1 answer
914 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 ...
user avatar
1 vote
1 answer
68 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 ...
user avatar
1 vote
1 answer
171 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 ...
user avatar
4 votes
1 answer
3k 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
user avatar
  • 157
0 votes
1 answer
50 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 ...
user avatar
  • 469
1 vote
1 answer
7k 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 "...
user avatar
2 votes
1 answer
36k 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 ...
user avatar
2 votes
1 answer
7k 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")...
user avatar
1 vote
1 answer
15k 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 ...
user avatar
3 votes
2 answers
9k 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(...
user avatar
  • 664
4 votes
1 answer
807 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 ...
user avatar
9 votes
1 answer
10k 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 ...
user avatar
  • 237
0 votes
1 answer
149 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 ...
user avatar
0 votes
1 answer
390 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 ...
user avatar
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 ...
user avatar
  • 845
0 votes
2 answers
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 ...
user avatar
4 votes
2 answers
481 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-...
user avatar
  • 1,911
2 votes
0 answers
214 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 ...
user avatar
-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?
user avatar
1 vote
1 answer
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, ...
user avatar
  • 391
13 votes
4 answers
9k 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.
user avatar
25 votes
1 answer
37k 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 ...
user avatar
25 votes
5 answers
27k 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 ...
user avatar
  • 613
1 vote
1 answer
849 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?
user avatar
1 vote
2 answers
78 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....
user avatar
  • 113