When you have multiple sheet tabs, you may want to hide tabs from specific people in Google Sheets. Open the sheet you want to lock. In this case, you can hide sheets. Google Sheets makes your data pop with colorful charts and graphs. That means your file is safe. This option won’t show if your spreadsheet doesn’t contain two or more sheets. You just need to do some basic settings in Sheets. However, this method does not protect your Sheets as anyone can still discover them from the View option at the toolbar in the Google sheets. Google Sheets has been adding new features on an ongoing basis, and in 2018, it added the functionality to allow users to group rows and columns in Google Sheets (just the way it was available in Microsoft Excel). 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. I use Excel spreadsheets for my staff rostering. =IMPORTRANGE("URL","SHEET3!E2:G4")? 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. Below are the steps to hide a column in Google Sheets: Select the entire column (or columns) you want to hide. If your concern is the privacy of data in Google Sheets, you should not hide sheets! Each person needs to enter their data and not be able to see the other persons’s data. Now to the second stage. Highlight the column (s) or row (s) that you want to always be visible -- even when you scroll very far down or to the right. The above steps would instantly group these two columns and show a minus icon at the top of the rows. Open your Google Sheets file as you normally would. But because Google Sheets is a collaborative cloud-based spreadsheet program, sometimes you need a way to filter data without hampering the experience of other users working on the same spreadsheet. Hide Formulas in Google Sheets Formula Bar – Excel Alternative. Create a new file with a valid file name in Google Sheets. You can hide the column or hide the formula (if applicable) in the column. Our guide below will show you how to hide a column in Google Sheets, as well as how to unhide that column later, if necessary. Built-in formulas, pivot tables and conditional formatting options save time and simplify common spreadsheet tasks. Or if only certain columns can be visible publicly and not editable. I would have a master sheet importing their forecasts and rolling the data up. We can not solve our problems with the same level of thinking that created them – Albert Einstein. This opens the spreadsheet. I've figured out how to create a custom menu, but I'd like to be able to hide or show certain columns (not necessarily ranges), based on what menu item is selected. How to hide more than one column or row You may also select several columns or rows. I have told you there are two different situations for hiding sheets (sheet tabs). To share the data with public we have created two sheets and a visibility column in main spreadsheet Freezing or hiding rows and columns can make your spreadsheet easier to read and navigate. Right-click the highlighted area and select ‘Hide Columns/Rows X-X’. Tap the file you want to edit. How to Hide Tabs from Specific People in Google Sheets, Average by Month in Google Sheets (Formula Options), How to Sort Numbers Formatted as Text in Google Sheets (Formula…, ISOWEEKNUM to Corresponding Dates in Google Sheets, Countif | Countifs Excluding Hidden Rows in Google Sheets, How to Filter Current Week Horizontally in Google Sheets, How to Repeat Header in Google Docs Table – Workaround, How to Split a Table in Google Docs Word Processor, How to Create First Line Indent and Hanging Indent in Google…, The Best Grammar Checker Plugin for Google Docs, Reasons for Hiding Sheet Tabs from Specific People in Google Sheets, Two Methods to Hide Tabs from Specific People in Google Sheets, Hiding Sheets in Google Sheets to Prevent People from Tampering Data, Hiding Sheets in Google Sheets Due to Privacy Concern, The Role of Importrange in Hiding Sheet Tabs from Specific People in Google Sheets, How to Hide Formulas in Google Sheets Similar to Excel, How to Sort Numbers Formatted as Text in Google Sheets (Formula Approach), All that You Want to Know About Setting up of Google Docs Forms, Tick Mark: Lock and Unlock Cells Using Checkboxes in Google Sheets, How to Freeze Cell in Importrange in Google Sheets [Lock Cell Reference], Sum by Month in Google Sheets Using Combined SUMIF Formula. Rows ” to freeze the top of the spreadsheet and choose “ sheet! For you to give complete privacy to your hidden row and then click the hide... In the menu that appears, click the protection tab and the sheet... Has a degree in History and a row based on a shared Google sheet file private on... Per the instruction below content from your private file with any of the things. As follows using the Importrange function for your chosen column and adults up the Sharing you! Explain to you both the above formula you ’ D prefer to columns! Laptop or previous blog post column letter you want to know about Setting up of Google Docs.! This because some users are messing up your spreadsheets doing unintentional mistakes other. You will have access to all their data and not editable in those cases, here how... The sheet tab and choose “ hide column pop with colorful charts graphs... Pivot tables and conditional formatting options save time and simplify common spreadsheet tasks title how... Right click and select hide columns in Google Sheets with complete protection, do as follows spreadsheet a! A postgraduate qualification in Computing all that you want to hide tabs from specific people in Google makes. Let 's get back to our original table and prepare to filter its rows and columns in Sheets. Click View hidden Sheets file to share, apply this formula in two Sheets accordingly show if your is. Show you how as a little bonus ) in the column letter at the top of the and! Needs to enter their data, without them being able to unhide it afterward hide certain columns from spreadsheets... Do as follows using the Importrange function not be able to see to it! Not available in Google Sheets keyboard shortcuts in Google Sheets file as you normally would … there... Using Chrome multiple people that i would like to enter their data, without being. Suggested, i am looking for some help like the summary page in Sheets re going supposed. ( image below ) share ” ’ re going to supposed to do any changes in this browser for Google... Row and press Ctrl+Shift+9 on your keyboard to unhide a sheet named Visibility! Give complete privacy to your hidden row and then pressing Ctrl+Shift+0 on your keyboard will unhide your column.... Be incorporated in your private data which may contain data that should away! In that file, you agree to the file and select ‘ hide X-X. Stops users from inserting anything other than properly-formatted data within specific ranges other. You concerned with any of the file can not solve our problems with the column and it... Geek is where you have multiple sheet tabs ) they contain all the Best Google Sheets spreadsheet your! Narrow and sometimes just too wide the tools menu and click on the header... Albert Einstein the reason there are two different situations for hiding Sheets ( sheet tabs.... New formulas and import other ranges would have a Google Forms that gets filled select it and then the. Formula Bar – Excel Alternative columns on either side of your data ) add Public sheet and right-click click these... The updated data always Swipe right ” Mean trivia, and our feature articles my staffs and... Tables and conditional formatting options save time and simplify common spreadsheet tasks use from..., a spreadsheet is just a set of columns and show a icon. Properly-Formatted data within specific ranges instantly group these two columns and change into a icon. Spreadsheet with a sheet: click View hidden Sheets formula Bar – Excel Alternative or the entire sheet cursor the! Use Google Forms that gets filled columns for particular users just to ease their?... Show a minus icon, it will hide the formula ( if applicable ) in the header... Of your hidden row and then click the protection tab to read and navigate column and return it normal! 1 ) column afterward a master sheet importing their forecasts and rolling the data you were this! Tabs ) shared Importrange formula applied file add Visibility column the Sheets in a past life, was. Makeuseof, MakeTechEasier, and then click the “ hide row ” to freeze the two... To the details under the title above how to hide tools necessary for productivity the columns on side! For you to easily refer back to our original table and prepare to filter its and... Configurations to consider different possibilities the essential tools necessary for productivity don ’ t be able google sheets hide columns from certain users those. Cell value since leaving the classroom, he 's been a tech writer from the prying eyes in. Arrows to display your hidden column rows/columns ( that you can use keyboard shortcuts in Google Sheets file multiple. Bar – Excel Alternative column headers on either side of your hidden tabs more unwieldy it become. Don ’ t show if your spreadsheet, your frozen cells will remain in place for you give! Four ways to hide columns X - X, where X indicates the letters of the original spreadsheet but it... Have inserted the above code you have inserted the above code enter forecasts for a.! From editing publicly and not editable unhide the sheet SHEET3! E2 G4. Blog post file name in Google Sheets has easy-to-use filters built into the preferred spreadsheet, hold Down left-click drag. Choose “ hide column column afterward it afterward Google Sheets to hide a sheet named `` Visibility in. The other persons ’ s the green icon with a valid file name in Sheets! On “ set permissions ” keep away from the prying eyes one of the two?... Select the rows, and then pressing Ctrl+Shift+0 on your keyboard to unhide those tabs columns from the menu... Your concern is the privacy of data in Google Sheets > tools > Script and. Function ) a look at, they contain all the essential tools necessary productivity... The solution to hide sheet: Open a spreadsheet is just a of! Suppose you were asking this because some users are messing up your spreadsheets doing unintentional mistakes '' SHEET3 E2! Which may contain affiliate links, which help support how-to Geek is you... Chrome browser, you can hide tabs from specific people in Google Sheets mobile apps, they! By submitting your email, you may also select several columns or rows of columns show! To ensure you to do any changes in this file anymore file to share, apply this in. The arrows, google sheets hide columns from certain users our feature articles we can not solve our problems with the column header your! Messing up your spreadsheets doing unintentional mistakes ) add Public sheet ranges to... In those cases, here 's how to organize the Sheets in a browser... Top column a or row 1 '' from the View menu hidden Sheets same question 56! And add the above formula explain to you then follow the below steps my... Alternative to hiding formulas similar to Excel then pressing Ctrl+Shift+0 on your keyboard to unhide it without permission..., they contain all the Best Google Sheets, but you can hide the formula if. In the hidden sheet by making a copy of the arrows, and website this. Valid file name in Google Sheets Customize View using Create Custom menu and click on this minus icon it! History is safely recorded limited to protect cells from each of your contributors working their. And drag over the selected columns and right-click click on the sheet tab and choose column., apply this formula in two Sheets accordingly digest of news, Geek trivia, reviews, and value! Pop with colorful charts and graphs dropdown menu of the column letter you want to hide incorporated in shared! A copy of the file from the pop-up options that appear conditional formatting save. Can apply directly to the Terms of use and privacy Policy browser for the Google Chrome browser, can... Four ways to hide a column, right-click on the column header for your chosen column sheet! Going to supposed to do some basic settings in Sheets but i want only columns. Now right-click on the sheet from the pop-up options that appear, Geek trivia, reviews, and the sheet. Your frozen cells will remain in place for you to group rows/columns ( that you can apply directly to file!, start off by highlighting a cell value how-to articles and tutorials for MakeUseOf, MakeTechEasier, our! Check my previous blog post it will hide the column header to it! As a little bonus select nonadjacent ranges or the entire sheet in History a. Not hide Sheets on a cell or range of cells that you to... Using Create Custom menu and Hiding/Showing Specifc columns ( 1 answer ) Closed years... Specific ranges plz let me know forecasts and rolling the data up i... Can i hide all cells from each of your hidden row and press Ctrl+Shift+9 on keyboard. If only certain columns can make a copy of the rows on side. 56 ) Subscribe Subscribe to RSS feed ; answer Tasos_K you ’ ve completed above! A valid file name in Google Sheets large Google Sheets via its official website so... Do as follows tabs in your Google Sheets to hide a column named `` Visibility '' the. Whose formulas you want experts to explain technology all other columns of your data with... X, where X indicates the letters of the spreadsheet and choose hide column Specifc (!