如何隐藏用户的某些列

如何隐藏用户的某些列

本文介绍了如何隐藏用户的某些列? (Google Spreadsheet)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

在共享的Google电子表格中:



我不希望我的域中的特定用户查看包含敏感数据的列,但这个人应该仍然可以编辑电子表格的其余部分。



我试着创建一个'主'电子表格并使用导入范围将数据导入'共享'表格,但是一旦我编辑共享电子表格中的任何单元格,如果工作表已被清空,则工作时间会更长。



是否有快速的方法来执行此操作,也许使用脚本?

导入区功能。



起初,我尝试使用隐藏栏&保护范围,但这是行不通的,因为简单的复制&粘贴会显示隐藏列的内容。解决方案:'主'电子表格没有任何敏感的列数据,可以与组织中的每个人共享。[/ b] 。然后,我将将敏感数据添加到新电子表格中,并使用导入范围从主中抓取内容。 (以前我的角色相反,但这不起作用)






您可能希望每行添加唯一的键因此当您压缩敏感数据和主数据时,排序等操作不会造成混乱。


On a shared Google spreadsheet:

I don't want a specific user in my domain to view columns with sensitive data, but this person should still be able to edit the rest of the spreadsheet.

I tried creating a 'master' spreadsheet and using importrange to bring the data into a 'shared' sheet, but once I edit any cell in the shared spreadsheet, importrange no longer works as the sheet is emptied out.

Is there a quick way to do this, maybe using scripting?

解决方案

After some research and trying various different options, I was finally able to achieve what I want using the importrange function.

At first, I tried using a combination of hide columns & protect range, but this wouldn't work because a simple copy & paste would reveal the contents of the hidden columns.

Solution: The 'master' spreadsheet does not have any sensitive column data and can be shared with everyone in the organization... I then ADD the sensitive data to a new spreadsheet and use importrange to grab contents from the 'master'. (Previously I had the roles reversed, but this didn't work)


You may want to add unique keys per row entry so that sorting etc won't mess things up when you zip-up the sensitive data and the 'master' data.

这篇关于如何隐藏用户的某些列? (Google Spreadsheet)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-12 14:55