About 1,880,183 results (4,078 milliseconds)
How to preserve formatting when cut and pasting across pages ...
https://support.google.com/docs/thread/136237697/how-to-preserve-formatting-when-cut-and-pasting-across-pages?hl=en Nov 19, 2021 ... After you Cut (or Copy), the Edit > Paste Special offers a number of options. The paste may include values only, or formatting only amongst other options too.
Is there a way to have values auto-paste over a formula using a ...
https://support.google.com/docs/thread/134031358/is-there-a-way-to-have-values-auto-paste-over-a-formula-using-a-formula?hl=en Nov 5, 2021 ... Change resetValue to true , like this: ... * Checkboxes work in Sheets on mobile as well as Sheets on web. * Functions run this way work without ...
Is there a way to copy an entire Spreadsheet with only values and ...
https://support.google.com/docs/thread/135780259/is-there-a-way-to-copy-an-entire-spreadsheet-with-only-values-and-no-formulas-links?hl=en Nov 16, 2021 ... I am wondering if there is a way to create a copy of a Spreadsheet where the copy contains entirely plain text and no formulas or links that way all the data ...
Problem with Excel, the VLOOKUP() function and ... - Google Answers
http://answers.google.com/answers/threadview/id/746309.html Jul 14, 2006 ... ... paste special value function of excel. I know that this is possible ... formula bar to convert the value from a number to text. [don't ...
How do I copy/paste a date w/o it changing to a random number ...
https://support.google.com/docs/thread/78364241/how-do-i-copy-paste-a-date-w-o-it-changing-to-a-random-number?hl=en Oct 21, 2020 ... You can then select Edit>Paste special>Paste values only. That would ... What I really need to know is how to I prevent this from happening and/or ...
No guide available about switching from Apple Numbers to Google ...
https://support.google.com/docs/thread/51120252/no-guide-available-about-switching-from-apple-numbers-to-google-sheets?hl=en Jun 3, 2020 ... Does Paste special take formulas that start with equals, and keep ... This is a file converted from Apple Numbers to Excel and THEN to sheets.
Copy paste a formula, only change 1 of the several references ...
https://support.google.com/docs/thread/132671332/copy-paste-a-formula-only-change-1-of-the-several-references?hl=en Oct 27, 2021 ... Relative references work great when you want to do the exact same thing using the values on the same row. Quantity column * Price column for ...
Issue with pasting currency data into Google sheets - Google Docs ...
https://support.google.com/docs/thread/12927879/issue-with-pasting-currency-data-into-google-sheets?hl=en Aug 27, 2019 ... You could use a formula to convert these values back to numeric values before you use it for a pivot table. If you'd like to see how to do ...
How can I convert copied text with numbers to actual numbers for ...
https://support.google.com/docs/thread/40936947/how-can-i-convert-copied-text-with-numbers-to-actual-numbers-for-calculations?hl=en Apr 18, 2020 ... Copying in the numbers into both Google Sheets and Excel 365 does not allow me to use the pasted numbers in formula's. ... Neither does the "paste ...
Is there a way I can change cell data without affecting the formula in ...
https://support.google.com/docs/thread/202835602/is-there-a-way-i-can-change-cell-data-without-affecting-the-formula-in-that-column?hl=en Feb 20, 2023 ... You cannot edit the output of a formula like you want. Your options are Copying the output of the formula and Special pasting it which will keep the output and ...
using wuery(importrange) to combine data from multiple ...
https://support.google.com/docs/thread/98092606/using-wuery-importrange-to-combine-data-from-multiple-spreadsheets?hl=en Feb 15, 2021 ... ... formulas into the one tab. I then copy, paste special w/ values only into another tab, and sort as needed. (I KNOW THERE IS A BETTER WAY ...
Pasting CSV to Google Sheets, it randomly inserts/deletes commas ...
https://support.google.com/docs/thread/266202269/pasting-csv-to-google-sheets-it-randomly-inserts-deletes-commas-but-not-with-other-separators?hl=en Mar 28, 2024 ... I will not continue to reply if this doesn't change. Second ... Fourth, paste (CTRL+V) and paste values only (CTSL+SHIFT+V) work ...
How can I paste text in a Google Doc without losing the formatting of ...
https://support.google.com/docs/thread/31547219/how-can-i-paste-text-in-a-google-doc-without-losing-the-formatting-of-the-original-text?hl=en Feb 26, 2020 ... It sounds as though you have Paste and match style on by default. This article explains how to toggle that.
Copy and paste text and images - Computer - Google Docs Editors ...
https://support.google.com/docs/answer/161768?hl=en&co=GENIE.Platform%3DDesktop Keyboard shortcuts · Paste values only: Pastes only the text from the original range of cells. · Paste format only: This option is identical to using the paint ...
How to paste a string that starts with spaces without losing the ...
https://support.google.com/docs/thread/98510396/how-to-paste-a-string-that-starts-with-spaces-without-losing-the-spaces?hl=en Feb 17, 2021 ... Or, a scripted solution may be possible to replace the spaces with special characters in your Doc. If you want to pursue that idea, start a new ...
How can I format a sheet so additional rows added will assume the ...
https://support.google.com/docs/thread/214192617/how-can-i-format-a-sheet-so-additional-rows-added-will-assume-the-same-formatting?hl=en May 4, 2023 ... If you are copy/pasting data, you would need to use Edit > Paste Special > Values Only. ... I would have had no idea how to accomplish this task ...
Google Sheets changing pasted numbers - Google Docs Editors ...
https://support.google.com/docs/thread/158670128/google-sheets-changing-pasted-numbers?hl=en Apr 5, 2022 ... ... formula. For example: Order number 1047480639529560 (copied from ... This special paste does its best to match the format of where you ...
How do I disable scientific notation on a spreadsheet? (e.g. convert ...
https://support.google.com/docs/thread/45190976/how-do-i-disable-scientific-notation-on-a-spreadsheet-e-g-convert-1-0006e-15-to-1000600000000700?hl=en May 7, 2020 ... (e.g. convert ... formulas, change the formatting for those cells to 'Plain Text'. When you copy and paste try to copy>paste special>values ...
Find and Replace - finds the string but when I want it replaced it says ...
https://support.google.com/docs/thread/39815474/find-and-replace-finds-the-string-but-when-i-want-it-replaced-it-says-that-it-can-t-find-the-strin?hl=en Apr 13, 2020 ... The value will always return to the output of the formula. I ... Paste Special > Paste VALUES only. This will convert the reference ...
I want the first letter of each word I type to be automatically ...
https://support.google.com/docs/thread/44410263/i-want-the-first-letter-of-each-word-i-type-to-be-automatically-capitalized-in-google-sheets?hl=en May 4, 2020 ... Right now I'm considering going to Google sheets or purchasing a newer version of Excel ... You could, if you wanted, Copy> Paste Special > Values ...