About 1,964,883 results (3,906 milliseconds)

How to hide columns on multiple sheets in a workbook - Google ...

https://support.google.com/docs/thread/119851005/how-to-hide-columns-on-multiple-sheets-in-a-workbook?hl=en
Aug 4, 2021 ... Shows and hides columns across multiple sheets as the user shows and hides them in a master sheet. Works with column grouping and regular column show/hide ...

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 ...

Need to share a sheet with Public but hide column B - Google Docs ...

https://support.google.com/docs/thread/108897187/need-to-share-a-sheet-with-public-but-hide-column-b?hl=en
May 6, 2021 ... I have a large and constantly updating spreadsheet I want to share with the users who have contributed to it.

hide/unhide column in protected sheet - Google Docs Editors ...

https://support.google.com/docs/thread/11052850/hide-unhide-column-in-protected-sheet?hl=en
Aug 1, 2019 ... I have spreadsheet with many column which is shared by few persons, every person have access to few column of their work, but they can't ...

Hide Columns based on a cell value

https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/AjuWeUbLAW0
Jul 3, 2009 ... I have a spreadsheet that i want to hide columns a:H if the value in cell. L1="N" and unhide if theres a "Y". i'd prefer for the "macro" to ...

Trying to hide cells when printing - Google Docs Editors Community

https://support.google.com/docs/thread/99268302/trying-to-hide-cells-when-printing?hl=en
Feb 22, 2021 ... I have a sheet where I want two sets of cells to show on my sheet ... By the way, I'm curious how you would do this in Excel - I'm not familiar ...

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 have a project tracking sheet with 18 columns and almost 1000 rows. I'd like to have custom views for different sets of those 18 columns.

Freeze, group, hide, or merge rows & columns - Computer - Google ...

https://support.google.com/docs/answer/9060449?hl=en&co=GENIE.Platform%3DDesktop
... rows or columns. On your computer, open a spreadsheet in Google Sheets. Select a row or column you want to freeze or unfreeze. At the top, click View and ...

Freeze, group, hide, or merge rows & columns - Android - Google ...

https://support.google.com/docs/answer/9060449?hl=en&co=GENIE.Platform%3DAndroid
In the menu that appears, tap Hide Row or Hide column. Group or ungroup rows or columns. On your Android phone or tablet, open a spreadsheet ...

Protect, hide, and edit sheets - Computer - Google Docs Editors Help

https://support.google.com/docs/answer/1218656?hl=en&co=GENIE.Platform%3DDesktop
To protect a sheet, click Sheet. Range: To change or enter the range you're protecting, click the spreadsheet icon and highlight the range in the spreadsheet.

How to hide the contents in a cell if it meets a certain condition ...

https://support.google.com/docs/thread/185741957/how-to-hide-the-contents-in-a-cell-if-it-meets-a-certain-condition?hl=en
Oct 25, 2022 ... Hi there – I am trying to hide the contents of all the cells in this worksheet that contain the date "1/30/2060. ... spreadsheet to show the ...

Based on the value of a checkbox, I want to hide or unhide a number ...

https://support.google.com/docs/thread/273827099/based-on-the-value-of-a-checkbox-i-want-to-hide-or-unhide-a-number-of-rows?hl=en
May 10, 2024 ... Several sections of a long worksheet apply or don't apply to a particular case. A series of cells with checkboxes near the top indicate the ...

Class Sheet | Apps Script | Google for Developers

https://developers.google.com/apps-script/reference/spreadsheet/sheet
Dec 2, 2024 ... ... columns after the first column on the first sheet of the // spreadsheet. ... column if it was previously hidden const range = sheet.

how can we unhide rows in google sheet - Google Docs Editors ...

https://support.google.com/docs/thread/10128182/how-can-we-unhide-rows-in-google-sheet?hl=en
Jul 18, 2019 ... But if you want to only unhide a specific row in Google Sheets then you simply click on the arrows on the Row Number Column and the hidden row(s) ...

Checkbox to Hide/Unhide Sheets - Google Docs Editors Community

https://support.google.com/docs/thread/154685236/checkbox-to-hide-unhide-sheets?hl=en
Mar 12, 2022 ... * numColumns The number of columns in the intersection. ... In your sample spreadsheet, the main sheet is not 'Main' but 'Cover ...

How can I protect the structure of a Google Sheets? - Google Docs ...

https://support.google.com/docs/thread/146789219/how-can-i-protect-the-structure-of-a-google-sheets?hl=en
Jan 20, 2022 ... Choose File > Make a copy to create a backup of the spreadsheet. ... Clear these instructions in the 'AnswerKey_new' sheet and hide columns K:V ...

count non empty cells in rows from a given column to a dynamic ...

https://support.google.com/docs/thread/148968711/count-non-empty-cells-in-rows-from-a-given-column-to-a-dynamic-column?hl=en
Feb 2, 2022 ... This code will find the first column with a date that is today or after, and hide columns up to the previous column. Your sample spreadsheet ...

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 ... 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.

How to limit what a shared user can see and edit in only some ...

https://support.google.com/docs/thread/97744851/how-to-limit-what-a-shared-user-can-see-and-edit-in-only-some-columns-in-google-sheets?hl=en
Feb 11, 2021 ... However, they could still edit the rest of the google sheet. I have searched online, some suggested hiding the columns I would like to not be ...