Carlow Home
   
Set a Workbook Password & Hide/Unhide Rows/Columns
   
Set a Password for Excel Workbook
  1. Open the Excel workbook file.
2. Left-click File in the menu bar
3. Left-click Save As….

For versions of MS Excel 97 and earlier,
4. Left-click Options… button in Save As screen
5. In the Save Options screen, File sharing section, type in a password for Password to open: area
(If you wish, you could also enter a password for Password to modify: area), then left-click OK button.

For versions of MS Excel 2000 and later,
4. Left-click Tools.
   
  5. Left-click on General Options.
6. Then, in the Save Options screen, File sharing section, type in a password for Password to open: area
(If you wish, you could also enter a password for Password to modify: area), then left-click OK button.
  NOTE: Passwords are case sensitive in Excel.
   
  6. In Confirm Password screen, type the password again in Reenter password to proceed area, then click OK.
7. Left-click Save button in Save As screen.
8. A Microsoft Excel prompt box appears, left-click Yes button to replace the existing file (workbook).
The next time someone tries to open the Excel workbook they get this prompt.
Enter the ‘open’ Password, then left-click OK.
   
  If a password was set for Password to modify:, in addition to Password to open:, you will also see the following prompt to Enter password for write access, or read only.
Enter the ‘modify’ password in Password:, then left-click OK.
   
 
Hide Row(s) or Column(s)
  1. Select the row(s) or column(s) you want to hide by using the left mouse button to click and drag or left-click and then use arrow keys to highlight cells.
2. Left-click Format on menu bar
3. Left-click either Row or Column
4. Left-click Hide
   
Unhide Row(s) or Column(s)
  1. Select the cells by using the left mouse button to click and drag or left-click and then use arrow keys to highlight the cells:
a) Display Hidden Rows: in the row above and in the row below the hidden row(s)
b) Display Hidden Column(s): in the column to the left and in the column to the right of the hidden column(s)
2. Left-click Format on the menu bar
3. Left-click either Row for row(s) or Column for column(s)
4. Left-click Unhide
Note: If the first row or column of a worksheet is hidden
1. Left-click Edit on menu bar
2. Left-click Go to
3. Type A1 in the Reference box and click OK button
4. Left-click Row or Column on the Format menu, and then left-click Unhide