Solved

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

Posted on 2014-09-26
5
180 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
Comment Utility
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
Comment Utility
Yes it is. Here's a step by step: http://www.excel-easy.com/examples/protect-sheet.html
0
 

Author Comment

by:cgilmartin
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks for the grade. Good luck.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
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…

763 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

12 Experts available now in Live!

Get 1:1 Help Now