Solved

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

Posted on 2014-09-26
5
202 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Outline Suppose you have some simple text based data in Excel that you would like to display as a PowerPoint presentation. Of course it would be possible to write some fairly complex VBA code that created a new slide for each line of the Excel data…
Gain an elementary understanding of Blockchain technology.
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
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…

615 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