Step 1 - Open "Excel Options" window from Excel Backstage View. You can achieve the same results explained in above method, using " Excel Options" Window.įollow below steps to hide Excel Row and Column headings or to show missing hidden Row and Column headings. Method 2 - Hide/Show Excel Row and Column headings from "Excel Options" windowĬlick the following link if you are not familiar with Excel Options Dialog Box Window
To hide Excel worksheet Row and Column headings.Ĭheck "Headings" checkbox to show missing hidden Excel worksheet Row and Column headings, as explained in below image.Īs you can see from the below image, Excel worksheet Gridlines is hidden now. Step 2 - Go to "Show" Group in Ribbon's "View" Tab. Step 1 - Click on "View" Tab on Excel Ribbon. To hide Excel worksheet Row and Column headings from Excel Ribbon, follow these steps Method 1 - Hide/Show Excel worksheet Row and Column headings from Excel Ribbon You can hide Excel worksheet Row and Column headers or show missing hidden Row and Column headers, by following any of below methods. Sometimes you may need to hide the Row numbers and Column letters to make more space for worksheet area. The Row numbers and Column Letters make it easy for a user to refer Cells inside Excel worksheet. Row number and Column letter combination is used to identify a Cell in Excel worksheet. The Row numbers and Column letters are one of the fundamental features of Excel worksheet. Only you, as a table owner, can see it.Excel worksheet Row and Column headings are the Column letters at the top of worksheet Columns and Row numbers at the left-side of worksheet Rows.Įxcel worksheet Row and Column headings are shown in below image. Hide the column by setting the column permission to: Column is hidden for contributors.Go to column settings by clicking on the gear icon on the header of any column you want to hide.With RowShare, you can hide any column you want with just a few clicks of a mouse! Follow these very simple steps: So, use Excel to analyze data, and RowShare to maximize your collaboration! On the other hand, it offers an effective way to collect and share information, which complements Excel. Alternative Solution, Simpler, Easier RowShare, an online collaborative table to the rescue! It is not meant to replace Excel. 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.