How do I put a password to an excel sheet?

Asked by Last Modified  

Follow 4
Answer

Please enter your answer

An UrbanPro Certified . . 5 Star Rated Trainer Committed to Your Learning!

Hi Ashish, Step 1) click on Review tab Step 2) in Changes group, click on Protect Sheet Step 3) enter Password Step 4) re-enter Password Note: in Step 2, You can select Option(s) for the User of the worksheet For more support on MS Excel, please refer https://support.office.com/ Hope, this helps. Thank...
read more
Hi Ashish, Step 1) click on Review tab Step 2) in Changes group, click on Protect Sheet Step 3) enter Password Step 4) re-enter Password Note: in Step 2, You can select Option(s) for the User of the worksheet For moresupport on MS Excel, please referhttps://support.office.com/ Hope, this helps. Thank You! read less
Comments

The shortcut to protect your workbook with password is to press Alt+T+P+P. It will open a popoup window to select options and insert password.
Comments

Related Questions

Should beginners learn excel VBA training online?
Hi Jayant, learning online should always be your second option. I am sure, the place where you live, there might be some coaching classes, tutors available who can teach you personally. This way, you...
Jayant
Is Excel online coaching much costlier than excel coaching classes?
You'll find numerous sites offering free training/material online. You may also learn directly from Microsoft excel product help. Join classes only if you need step by step guidance and monitoring
Radha

What is the use of Data validation commond. can you demonstare the example in common life?

The point of data validation is to pick the list in a drop down fashion. It will ease your work by allowing you to select the entries from the drop down rather than you writing for it. It saves a lot of time when it comes to large dataset.
Anil
0 0
5
Why do we use a dollar sign in Excel?
A dollar sign $ is called a locked cell reference. Locked cell references are one of the building blocks of Excel modeling. Without them, you will waste endless amounts of time re-writing formulas.
Poonam
0 0
8
Are skills in Excel VBA useful to have?
Yes the skills are very useful
Kalpana

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

MS Project: Linking tasks of other projects
In MS Project, user may want to create a dependancy between tasks of multiple projects, which is also called as external dependancy. This video explains how to create external dependancy in MS Project...

MS Project: Copy calendar from one project to another project
Sometimes user may want to use same calendar of existing project in another project. In such case, there is no need to recreate new calendar in second project. This video explains how copy existing calendar from one project to another project.


Hidden Gems of MS Excel - New Window
You are working on 2 Worksheets in Same Workbook. To complete Your task, You have to frequently navigate between the Worksheets.Understandably, to frequently navigate between the Worksheets is inconvenient,...

Recommended Articles

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you