Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2014-09-26
5
Medium Priority
?
213 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 21

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 21

Accepted Solution

by:
netcmh earned 2000 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 21

Expert Comment

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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
Gain an elementary understanding of Blockchain technology.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Integration Management Part 2

824 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