![how do i unhide a column in excel 2010 how do i unhide a column in excel 2010](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2015/04/excel-2010-unhide-everything-1.jpg)
![how do i unhide a column in excel 2010 how do i unhide a column in excel 2010](https://www.techonthenet.com/excel/columns/images/unhide_cola2010_001.gif)
![how do i unhide a column in excel 2010 how do i unhide a column in excel 2010](https://d3mkpw26g447am.cloudfront.net/images/6b88f98a2b81e49ea74f43e89e30eef0.png)
Use F5 to jump to the locked and hidden cell, then press Ctrl+C, move to the unlocked cell, and press Ctrl+V. Copy the contents of the locked and hidden cell and paste it in the unlocked cell.For instance, if column E is locked and hidden, entering the formula =E3 will display, in the unlocked cell, the value in cell E3. In the unlocked cell, enter a formula that references a locked and hidden cell.There is one caveat to all this: If you have some cells in the worksheet (or workbook) that are unlocked, so that the contents of the cell can be changed, it is still possible to see what is in individual cells of the column.
#How do i unhide a column in excel 2010 password#
You are prompted to reenter your password (the one from step 9), which you should do.Īt this point someone cannot view what is in the hidden column, even if they use F5 to jump to one of the cells in the column it still won't appear in the formula bar. (These two options are selected by default in a worksheet.) At a minimum you should choose Select Locked Cells and Select Unlocked Cells.
#How do i unhide a column in excel 2010 how to#
Since you already know how to protect a worksheet, you are already on your way to accomplishing your task. He knows how to protect the worksheet and how to hide data in cells but noticed that info is still visible in the formula bar. He wants to hide some of the columns in the worksheet, however, so that they cannot be viewed by users. Roger has a worksheet that he needs to distribute to different people so they can add and change some information.