Solved

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

Posted on 2014-09-26
5
182 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

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…
A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

914 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now