About 1,070,638 results (4,576 milliseconds)
How can I exclude hidden cells from calculations, and only count the ...
https://support.google.com/docs/thread/146564069/how-can-i-exclude-hidden-cells-from-calculations-and-only-count-the-visible-cells-in-a-range?hl=en Jan 19, 2022 ... Hidden values keep getting pasted. Unfortunately, can't share the sheet as it's a work document with data I can't share externally. But I ...
Sorting data while maintaining grouped rows - Google Docs Editors ...
https://support.google.com/docs/thread/95220223/sorting-data-while-maintaining-grouped-rows?hl=en Jan 26, 2021 ... I have a Google Sheet in which I keep historical stock data. ... What is interesting is if I HIDE all rows, except for the rows that ...
Is there a way to prevent sheets from printing data in a cell or entire ...
https://support.google.com/docs/thread/204812685/is-there-a-way-to-prevent-sheets-from-printing-data-in-a-cell-or-entire-column?hl=en Mar 5, 2023 ... ... without this additional data. I know I can hide the column, but I was hoping there's a way to mark the cell or column to be ignored for printing ...
Resizing column width
https://groups.google.com/g/openrefine/c/H3FAf5DSHPk Jul 12, 2017 ... I know I can hide columns, but what I am hoping for is to keep a ... Should the header row separators be the norm , like Excel uses, etc ?
Is there a good way to organize the hidden sheets so they're easier ...
https://support.google.com/docs/thread/121657530/is-there-a-good-way-to-organize-the-hidden-sheets-so-they-re-easier-to-find-navigate-from-the-tab?hl=en Aug 17, 2021 ... ... data, without disturbing others, and without leaving the data tab. ... The primary benefit of a row-oriented data layout that it makes it ...
How to keep a formula to apply to new entries from a form - Google ...
https://support.google.com/docs/thread/112029366/how-to-keep-a-formula-to-apply-to-new-entries-from-a-form?hl=en Jun 1, 2021 ... Also, you run the risk of your data become corrupted. I would suggest that you keep the responses sheet intact, and you can also hide it from ...
hide columns based on user input cell? - Google Docs Editors ...
https://support.google.com/docs/thread/8844320/hide-columns-based-on-user-input-cell?hl=en Jun 27, 2019 ... If you look at the worksheet called "Hide Columns", call A3 is the data entry point for the user. In my live sheet, I have conditional ...
Excel crak google sheet protection !!! - Google Docs Editors ...
https://support.google.com/docs/thread/10171942/excel-crak-google-sheet-protection?hl=en Jul 18, 2019 ... ... unhide the sheet(s) and see all the data that were hidden. Please, do you have any solution to help me to keep the protection and the hidden ...
How to hide specific rows or columns in an active Google Sheet from ...
https://support.google.com/docs/thread/8210462/how-to-hide-specific-rows-or-columns-in-an-active-google-sheet-from-shared-users?hl=en Jun 17, 2019 ... What to do? - If you have info that you do not want to share with certain users, keep that info on a sheet that is not shared with those users.
Copy/paste visible cells only - Google Docs Editors Community
https://support.google.com/docs/thread/4604028/copy-paste-visible-cells-only?hl=en Apr 21, 2019 ... Hi everyone, I can't for the life of me figure out how to copy and paste visible cells only from a sheet where I've hidden bunch of columns.
Copy/paste visible cells only - Google Docs Editors Community
https://support.google.com/docs/thread/100192443/copy-paste-visible-cells-only?hl=en Feb 28, 2021 ... I don't believe that just hiding rows offers any way of excluding that data from a copy and paste - it seems to require the data filter approach ...
Protect formulas without using Protected Ranges - Google Docs ...
https://support.google.com/docs/thread/183571344/protect-formulas-without-using-protected-ranges?hl=en Oct 12, 2022 ... I've put a Data Validation in the cells to be =A2=(the formula in ... what if you had the formulas in a hidden row or column,. and. then ...
How do I filter out rows on a sheet that are highlighted a certain color ...
https://support.google.com/docs/thread/18286071/how-do-i-filter-out-rows-on-a-sheet-that-are-highlighted-a-certain-color-which-you-can-in-excel?hl=en Nov 1, 2019 ... I want to keep the data in the sheet, just temporarily remove all ... column in your filter to temporarily hide the duplicates. If you ...
Can you enter multiple data in one cell and parse them separately ...
https://support.google.com/docs/thread/7671180/can-you-enter-multiple-data-in-one-cell-and-parse-them-separately-when-referencing-the-cell?hl=en Jun 8, 2019 ... After watching some more videos on it, I keep hearing people repeat that it's going to be set to False most of the time, and it doesn't sound ...
Automatically Hide/Reveal Rows Without Text - Google Docs Editors ...
https://support.google.com/docs/thread/217673738/automatically-hide-reveal-rows-without-text?hl=en May 26, 2023 ... I'm wondering if it's possible to create a script/formula to automatically hide empty rows that will reveal them if data is added.
How can I keep my filter but remove the green border? - Google ...
https://support.google.com/docs/thread/2234563/how-can-i-keep-my-filter-but-remove-the-green-border?hl=en Mar 10, 2019 ... I am using a filter in Sheets. I want to keep using the filter, but I don't like how there is a green border around the column that my filter is using.
Freeze, group, hide, or merge rows & columns - Android - Google ...
https://support.google.com/docs/answer/9060449?hl=en&co=GENIE.Platform%3DAndroid You can freeze, group, hide, or merge your spreadsheet's columns, rows, or cells. ... Learn to work on Office files without installing Office, create dynamic ...
Trying to sequentially number instances of duplicate entries (1st ...
https://support.google.com/docs/thread/79817164/trying-to-sequentially-number-instances-of-duplicate-entries-1st-2nd-3rd-etc?hl=en Oct 29, 2020 ... ... without losing those duplicate entries or having to move them ... You can hide the helper column N if it gets in the way. As you can ...
Conditional Formatting checking a match in a second table - Google ...
https://support.google.com/docs/thread/116997818/conditional-formatting-checking-a-match-in-a-second-table?hl=en Jul 13, 2021 ... ... without adding the extra data column. The conditional formatting ... You can hide column E or move it to the far right of the Overview ...
How to set custom view filter columns in Google Sheets? - Google ...
https://support.google.com/docs/thread/2266784/how-to-set-custom-view-filter-columns-in-google-sheets?hl=en Mar 12, 2019 ... I've made good use of the Filter Views, but these only hide info within the column - not the whole columns themselves. What solution would you ...