About 1,593,514 results (5,354 milliseconds)
Not see all the info in a cell. - Google Docs Editors Community
https://support.google.com/docs/thread/102586210/not-see-all-the-info-in-a-cell?hl=en Mar 17, 2021 ... Another option is to set the cell (or column or row) properties so that cells "wrap" any text that doesn't display on one row, automatically ...
How can I get cells w/ formulas to show the full value rather than the ...
https://support.google.com/docs/thread/115366223/how-can-i-get-cells-w-formulas-to-show-the-full-value-rather-than-the-formula-when-double-clicking?hl=en Jun 29, 2021 ... I'd like to be able to double click into the cells and have the entire values show in the pop up window like if the cell was only just a text value.
? How to AUTOMATICALLY FIT the Row Height to accommodate the ...
https://support.google.com/docs/thread/10178653/how-to-automatically-fit-the-row-height-to-accommodate-the-actual-text-in-the-cell-s-in-the-row?hl=en Jul 18, 2019 ... How to AUTOMATICALLY FIT the Row Height to accommodate the actual text in the cell(s) in the row. I need to optimize the display of a google ...
"Invalid: This cell's contents violate its validation rule" - Google Docs ...
https://support.google.com/docs/thread/150363758/invalid-this-cell-s-contents-violate-its-validation-rule?hl=en Feb 11, 2022 ... You can view the validation through menu: Data > Data validation. It seems to deny input if the cell in column A does not set as Locked.
How do I fix Cell Alignment that Exceeds Cell Boundaries? - Google ...
https://support.google.com/docs/thread/29596812/how-do-i-fix-cell-alignment-that-exceeds-cell-boundaries?hl=en Feb 23, 2020 ... Deleted, re-made sheets, copy/cut/pasted with or without 'values only';; Everything else on the internet which I could find. Thank you! Details.
How to copy exact contents of a cell with randbetween to another ...
https://support.google.com/docs/thread/52387526/how-to-copy-exact-contents-of-a-cell-with-randbetween-to-another-cell?hl=en Jun 9, 2020 ... I'd like to display that same exact post content on another sheet showing a calendar, but when I reference the cell in question, ...
How to reference cells value and not it's formula - Google Docs ...
https://support.google.com/docs/thread/6274141/how-to-reference-cells-value-and-not-it-s-formula?hl=en May 16, 2019 ... Or if the above cell equals 11 then this cell should display some other value. The problem is that google sheets isn't seeing the resulting ...
Read & write cell values | Google Sheets | Google for Developers
https://developers.google.com/workspace/sheets/api/guides/values Jun 4, 2025 ... A cell is a location at the intersection of a particular row and column, and might contain a data value. The Google Sheets API provides the ...
Google sheets wont display formula results, I only see the formula in ...
https://support.google.com/docs/thread/2758245/google-sheets-wont-display-formula-results-i-only-see-the-formula-in-the-cell?hl=en Mar 20, 2019 ... The View>Show Formulas is off (not checked). Only the formula displays in the cell, not the value. Please help.
Reference cell data from another Google spreadsheet (not a ...
https://support.google.com/docs/thread/8274394/reference-cell-data-from-another-google-spreadsheet-not-a-different-tabbed-sheet?hl=en Jun 18, 2019 ... Is there a way to do this without typing the whole formula? What I mean is, say I have document A and B in Excel. If I want to copy a value in a ...
How to Detect Cells that Failed Data Validation - Google Docs ...
https://support.google.com/docs/thread/174285217/how-to-detect-cells-that-failed-data-validation?hl=en Aug 8, 2022 ... ... View" to display all lines with invalid or missing data). My question is how do I tell if a cell has an error? Functions such as "IsError ...
Formula question - Cell text dependent on 3 separate True/False ...
https://support.google.com/docs/thread/20726612/formula-question-cell-text-dependent-on-3-separate-true-false-cell-values?hl=en Nov 21, 2019 ... I have three cells that can have a value only of either TRUE or FALSE (checkbox). I would like a separate cell to display different text based on the breakdown ...
The text in Google sheets is overlapping other cells, and I don't ...
https://support.google.com/docs/thread/238403252/the-text-in-google-sheets-is-overlapping-other-cells-and-i-don-t-understand-why?hl=en Oct 9, 2023 ... Based on my experience, if I have text in cell A1 that goes over the cell size, and I also have text in B1, then the A1 cell should only show ...
How to add notes based on cell content? - Google Docs Editors ...
https://support.google.com/docs/thread/25883950/how-to-add-notes-based-on-cell-content?hl=en Jan 16, 2020 ... It is not too clear. So this is a wild guess. See the formula in cell J9. =iferror(query({Sheet1!B9:C23}, " select * where lower(Col2) ...
Conditional formatting on one box, dependent on content in another ...
https://support.google.com/docs/thread/26310576/conditional-formatting-on-one-box-dependent-on-content-in-another-box?hl=en Jan 21, 2020 ... I am building an encompassing hours spreadsheet for various overhire staff. ... I want, for example, cell B5 on sheet 1 to show the content of ...
How to SUBSTITUTE cells with other values ONLY when the ...
https://support.google.com/docs/thread/60109727/how-to-substitute-cells-with-other-values-only-when-the-replacement-matches-entire-cell-content?hl=en Jul 20, 2020 ... I need to SUBSTITUTE cells with other values when the replacement matches entire cell content. ... Please spare a minute to look at the ...
How can I tab in a table cell? - Google Docs Editors Community
https://support.google.com/docs/thread/12434319/how-can-i-tab-in-a-table-cell?hl=en Aug 20, 2019 ... As long as you have the ruler visible first (via View > Show ... For something on the fly, such as intermittent cells that need minimal content ...
Using TEXT formula, blank cell adds data and skews reporting ...
https://support.google.com/docs/thread/120071718/using-text-formula-blank-cell-adds-data-and-skews-reporting?hl=en Aug 5, 2021 ... I need it to not add data from the blank cell. I am not sure how to show you the project since it cannot be downloaded and I cannot share it ...
How to Display data based on multiple Criteria - Google Docs ...
https://support.google.com/docs/thread/68461262/how-to-display-data-based-on-multiple-criteria?hl=en Sep 2, 2020 ... Try this formula on your own. In cell A1 of the Sheet2 place this formula: The QUERY will return anything from columns A and B when C=TRUE and D=FALSE.
Why are 'longer' cell contents not aligning properly? - Google Docs ...
https://support.google.com/docs/thread/11232356/why-are-longer-cell-contents-not-aligning-properly?hl=en Aug 3, 2019 ... In the example image, we see that the longer a string, the more offset the text becomes. Details. Sheets,Microsoft Windows,Business. Locked.