About 1,288,785 results (2,061 milliseconds)
How do I leave previous cells unchanged if condition is met in ...
https://support.google.com/docs/thread/82793060/how-do-i-leave-previous-cells-unchanged-if-condition-is-met-in-proceeding-cell?hl=en Nov 13, 2020 ... Cell AF1 has the cap for Broker Split and cell AG1 has the cap for Company Split. ... whole column that it refers to on the other side of the ...
help with commissions IF calculations - Google Docs Editors ...
https://support.google.com/docs/thread/104534025/help-with-commissions-if-calculations?hl=en Mar 31, 2021 ... Then you just need the sum of that column to give the total commissions for Q1. ... cells, or even a whole column (or row, or both). So the ...
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 ... Wanting the first letter of each word to be automatically capitalized when I type for the entire sheet. I have downloaded an add-on that will do this in for ...
How can I protect cells in my Google sheet when it is stored on ...
https://support.google.com/docs/thread/114640667/how-can-i-protect-cells-in-my-google-sheet-when-it-is-stored-on-somebody-else-s-drive?hl=en Jun 23, 2021 ... We have a company drive with some google sheets forms that are used on a regular basis. When I make a copy of a form, it says I am the owner ...
Query function not returning all data - Google Docs Editors Community
https://support.google.com/docs/thread/187549444/query-function-not-returning-all-data?hl=en Nov 7, 2022 ... This is due to QUERY does not like mixed data types in the same columns. To fix the issue, select the entire data range, then in your top menu ...
Can't change case in google sheets Format->Text menu ...
https://support.google.com/docs/thread/237941540/can-t-change-case-in-google-sheets-format-text-menu?hl=en Oct 5, 2023 ... I know I can use the LOWER function but that creates an entire new set of cells and seems like a lot of steps to go through. I found that in ...
Google Docs is suddenly scaling my doc when time to print - Google ...
https://support.google.com/docs/thread/5985160/google-docs-is-suddenly-scaling-my-doc-when-time-to-print?hl=en May 12, 2019 ... My paper size is "letter." After Googling this problem and reading a few things, I tried changing the paper size to A4, but that made it look ...
How do I delete lower case entries in a column - Google Docs ...
https://support.google.com/docs/thread/10501077/how-do-i-delete-lower-case-entries-in-a-column?hl=en Jul 23, 2019 ... and delete each entry that is in all lowercase. Does that make sense? Details. Sheets,Mac OS,Business.
Set up conditional formatting that is also case sensitive - Google ...
https://support.google.com/docs/thread/225325361/set-up-conditional-formatting-that-is-also-case-sensitive?hl=en Jul 13, 2023 ... Or would it be better to make a different sheet (like a formula one), list all the names from Rates!B2:B, have a second column referring to the ...
How to set rules for your form - Google Docs Editors Help
https://support.google.com/docs/answer/3378864?hl=en You can create rules that people have to follow when they fill out your form. For example, if you ask for email addresses, you can make sure that people can ...
Automatically change all text in certain cells to uppercase - Google ...
https://support.google.com/docs/thread/193162823/automatically-change-all-text-in-certain-cells-to-uppercase?hl=en Dec 16, 2022 ... 1. Right-Click desired Column and select Data Validation. 2. In the Data Validation pop-up, select the + Add rule. 3. Make sure your Apply to Range is set to ...
How do I use Find & Replace to change a lowercase character to an ...
https://support.google.com/docs/thread/191932410/how-do-i-use-find-replace-to-change-a-lowercase-character-to-an-uppercase-in-a-google-sheets?hl=en Dec 8, 2022 ... New to Formulas in Google Sheets. I was able to add a new column with the formula and it translates the lowercase characters to uppercase in the ...
Formulas to reflect filter and omit hidden rows - Google Docs Editors ...
https://support.google.com/docs/thread/74937318/formulas-to-reflect-filter-and-omit-hidden-rows?hl=en Oct 4, 2020 ... I'd like you to make the following adjustment on your real sheet. Delete all the column headers in row 5 (The blue row "School", "ID #", " ...
Split Names - Google Workspace Marketplace
https://workspace.google.com/marketplace/app/split_names/1072896854591 Jul 5, 2024 ... 7 ***** Improved: - UX Fixed: - The add-on didn't recognize names in UPPERCASE - Processing the whole column - Minor bugs Added: - We introduced ...
Convert column with text into a drop down menu - Google Docs ...
https://support.google.com/docs/thread/155506813/convert-column-with-text-into-a-drop-down-menu?hl=en Mar 18, 2022 ... You can create such lists like this: Select the cells in the range where you want the drop-down lists, say Sheet1!L2:L10 . Choose Data ...
Query/ImportRange resulting in #REF! error, even when using ...
https://support.google.com/docs/thread/5749488/query-importrange-resulting-in-ref-error-even-when-using-correct-syntax?hl=en May 8, 2019 ... I'm trying to import a range from another google sheet, but only the rows where the value in column F is greater than zero.
merged cells and creating charts
https://groups.google.com/g/microsoft.public.excel.charting/c/WkXdUWcpGcw Oct 8, 2009 ... They can be used for column heading but for little else. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme
Keyboard shortcuts for Google Docs - Computer - Google Docs ...
https://support.google.com/docs/answer/179738?hl=en&co=GENIE.Platform%3DDesktop To open a list of keyboard shortcuts in Google Docs, press Ctrl + / (Windows, Chrome OS) or ⌘ + / (Mac). Tool finder (formerly search the menus), press Alt + /.
How to remove unwanted spaces - Google Docs Editors Community
https://support.google.com/docs/thread/188915830/how-to-remove-unwanted-spaces?hl=en Nov 16, 2022 ... I have tried the "TRIM" formula, but it only removed some spaces and did not remove ALL spaces between the characters as needed.
Change how paragraphs & fonts look - Computer - Google Docs ...
https://support.google.com/docs/answer/1663349?hl=en&co=GENIE.Platform%3DDesktop You can use the buttons in the toolbar at the top of a document to: Edit and format the text and paragraph spacing; Change the font and background color ...