#UNHIDE FIRST COLUMN IN EXCEL 2003 HOW TO#
#UNHIDE FIRST COLUMN IN EXCEL 2003 PASSWORD#

At a minimum you should choose Select Locked Cells and Select Unlocked Cells.

Using the check boxes, select what type of protection you want applied to the worksheet.

#UNHIDE FIRST COLUMN IN EXCEL 2003 PASSWORD#

Enter a password to be used in protecting the worksheet.

Excel displays the Protect Sheet dialog box.

Choose Tools | Protection | Protect Sheet.

With the column still selected, choose Format | Column | Hide.

(It is the Hidden check box that controls whether the cell contents are visible in the formula bar or not.)

Make sure both the Locked and Hidden check boxes are selected.

The Protection tab of the Format Cells dialog box.

Make sure the Protection tab is displayed.

Excel displays the Format Cells dialog box.

#UNHIDE FIRST COLUMN IN EXCEL 2003 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. Your previously missing column A magically reappears.Roger has a worksheet that he needs to distribute to different people so they can add and change some information.

When your mouse pointer changes to this special double-headed arrow, all you have to do is right-click and choose Unhide. It is different, however, because instead of a black line dividing the double arrows, there are two black lines with a gap between them. This double-headed arrow is a bit difficult to describe it looks most closely like the double-headed arrow that appears when you position the pointer over the dividing line between column headers. If you move your mouse pointer into the column header area, and then slowly move it to the left, you notice that it turns into a double-headed arrow with a blank spot in the middle as you position the pointer over the small area immediately to the left of the column B header. You can then choose Column from the Format menu and then choose Unhide.ДЄ third method is even niftier, provided you have a good eye and a steady mouse pointer. If you release the mouse button when the pointer is over the gray block that marks the intersection of the row and column headers (the blank gray block just above the row headers), then column B and everything to its left, including the hidden column A, are selected. Choose Column from the Format menu, then choose Unhide.ДЄnother way to display the first column is to click on the header for column B, and then drag the mouse to the left.Cell A1 is now selected, even though you cannot see it on the screen. In the Reference field at the bottom of the dialog box, enter A1.

Choose Go To from the Edit menu, or press F5.To unhide the left-most columns of a worksheet when they are hidden, follow these steps: If you later want to unhide column A, the solution isn't so obvious. For instance, if you hide column A, Excel will dutifully follow out your instructions. What isn't so easy is displaying a hidden column if that column is the left-most column in the worksheet. Excel makes it easy to hide and unhide columns.

Unhide first column in excel 2003