On the other hand, it offers an effective way to collect and share information, which complements Excel. Grouping inserts small icons around the Excel grid to allow you to hide and unhide rows and columns quickly and easily. A double-line between Column letter A and Column. You can see from below images that the selected Columns in above example are hidden. After selecting the Columns, right-click on the selected Columns and click 'Hide' from the context menu as shown below. Alternative Solution, Simpler, Easier RowShare, an online collaborative table to the rescue! It is not meant to replace Excel. To hide Columns from Excel worksheet, first select the Columns which you want to hide. This means that anyone accessing your Excel Online file can unhide your hidden column. Note: If you use Excel online, you can hide a column but you can’t lock it.

Send the new modified version to all users.Each time you need to see the make any modifications, you need to do the following steps: If you prefer to share your Excel the old-fashioned way, then another option is share it by email. It means that if there is another user accessing your file at the same time as you modify it, he/she would see your hidden information. Note: The file stored in the cloud is shared in real-time. As you store your Excel file in the cloud, each time you need to see or modify the hidden column(s), you must do the following steps: Give the cloud access link to anyone you want to share your Excel file. Sharing The File The option one is: to store your Excel file in the cloud such as One Drive, Dropbox or Google Drive. In case you want certain users to see the hidden column, you can send them the password, but, this also means that they can share your file with another person. Note: If you lose your password you can’t never modify your sheet anymore. You can do this by following these simple steps: So, to prevent this from happening, all you need to do is locking your Excel file once you hide the selected columns by protecting your sheet with password. Note: After the selected column is hidden, anyone with whom you share the file can still unhide the column. Right click on the header of any column you want to hide.You can hide columns in Excel by following these simple steps:

Secondly, we will see how RowShare, an online collaborative table complementing Excel, responds to this need.

Here, we will firstly see how Excel (or Excel Online) may respond to this need. When you work with multiple collaborators in Excel, do you ever need to hide some columns because you don’t want them to see the information of that certain column?Like hiding sensitive columns such as salary information in a list of employees for example? Perhaps you don’t just want the information to be visually hidden, but you want to literally prohibit them from accessing it.

Hide columns in excel