Solved

How do I password protect a worksheet within a workbook in Excel 2013

Posted on 2014-09-26
5
188 Views
Last Modified: 2014-10-01
I know how to password protect a workbook, but I want to password protect a worksheet within.  Is this possible?
0
Comment
Question by:cgilmartin
  • 3
5 Comments
 
LVL 9

Expert Comment

by:Trenton Knew
ID: 40346456
Right-click the sheet's tab and click protect sheet, then enter a password you want to use for unprotecting the sheet
0
 
LVL 20

Expert Comment

by:netcmh
ID: 40346464
Yes it is. Here's a step by step: http://www.excel-easy.com/examples/protect-sheet.html
0
 

Author Comment

by:cgilmartin
ID: 40346477
I wasn't clear in my original questions.  Sorry.

i want to password protect the sheet from someone viewing it.  Not just elements in the sheet, but actually viewing it.
0
 
LVL 20

Accepted Solution

by:
netcmh earned 500 total points
ID: 40346499
Right-click on the worksheet that you want to hide and protect
Click Hide.
Go to Review > click Protect Workbook and enter a password, ensure that Structure is checked and click OK.
Save and close the Excel.

When you re-open the workbook, the sheet that you have hidden is hidden until you click Unprotect Workbook and enter the correct password.
0
 
LVL 20

Expert Comment

by:netcmh
ID: 40355200
Thanks for the grade. Good luck.
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question