We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Is it possible to "show/hide" columns on a protected sheet?

asked 2018-12-16 22:14:27 +0200

Charlie GoodDog gravatar image

updated 2021-06-12 00:23:36 +0200

Alex Kemp gravatar image

I have a sheet with 12 columns (Jan to Dec). I have formulas in most of the cells in the columns and I have protected the sheet to prevent changes. I wish to allow users to show and hide columns as they want. I cannot make this work on a protected sheet. Is it possible to do?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-12-16 23:18:55 +0200

m.a.riosv gravatar image

I think you can do it with Menu/Data/Group & Outline

Help Group and Outline

edit flag offensive delete link more


Thanks. This kind of works but not quite the way I would like. My data is in columns "D" through "O". Today I may want to show "F' and "G" but not the rest. Tomorrow I may want to show "G" and "H" but not the rest, etc.I do it now on an unprotected sheet by selecting the columns before and the columns after the columns I want to display, then right clicking and selecting "hide". Easy and simple. I want to do this on a protected sheet.

Charlie GoodDog gravatar imageCharlie GoodDog ( 2018-12-17 02:34:56 +0200 )edit

I think no way, protect between other it's for that.

m.a.riosv gravatar imagem.a.riosv ( 2018-12-17 22:49:09 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-16 22:14:27 +0200

Seen: 221 times

Last updated: Dec 16 '18