Excel protect

Contents:
Encrypt excel fileProtect workbook | Protect worksheet

How do I encrypt an excel file in excel 2013? How to encrypt excel workbook? How to encrypt an excel file with a password in Microsoft excel? This post will guide you how to encrypt excel file, protect workbook and protect worksheet in excel.

Encrypt excel file

There are three kinds of encrypt way in excel as below:

  • Password to open
  • Password to modify
  • Read-only recommended

Password to open”, it means that while you opening a workbook, you need to input a password.

Password to modify”, it means that if you want to modify the workbook, then you must input a password, or you just only can read it.

Read-only recommended”, it means that you can read-only the excel workbook if you do not know the password.

Let’s see the below steps to encrypt excel file:

1# open an existing workbook or create a workbook

2# click “File” Tab, then click “Save As

excel protect save as

3# click “Tools” button, then click “General Options…”, the “General Options” window will appear.

excel protect general options

4# enter a password in “password to open” or “password to modify” box.

excel open password

5# Reenter password to proceed. Click “ok” button, then click “save” button

excel confirm password

6# try to reopen the above excel workbook, then you need to type password so that it can continue to open.

excel protect reopen workbook

7# if you want to make your workbook with read-only, just checked “Read-only recommended” option in “general options”.

excel read only recommended

8# re-open excel file, one window will be pop up.

excel read only workbook

Protect workbook

The below steps will explain that how to protect the workbook structure and window in excel:

Protect structure-user is not able to do the following operation for the current workbook: Insert, Delete, Rename, Move or Copy, Hide, Unhide and set tab color.

Protect window-this option is only available in excel 2010 and earlier. If you checked “windows” option, the users is not able to moving, resizing or closing the current workbook window. And the protect windows option is unavailable in excel 2013 and later versions.

1# open a workbook or create a new workbook

2# On “REVIEW” Tab, click “Protect Workbook” on “Changes” group.

excel protect workbook structure

3# Enter a password in the Password box.

4# Retype the password to confirm it.

5# if you want to unprotect workbook, just click “protect workbook” again, then enter the password.

excel unprotect workbook

Protect worksheet

If you want to protect a worksheet to prevent users from changing, moving, or deleting data in a worksheet, you can lock the cells on your current excel worksheet and also you can protect the worksheet with a password. The below steps will explain that how to protect the worksheet:

1# on “REVIEW” tab, click “Protect Sheet”, then “protect sheet” window will appear.

excel protect worksheet

2# Reeter password to proceed.

excel confirm password

3# now try to modify worksheet data, and let’s see the result:

excel protect worksheet result

Related Posts

Delete Rows Based on Cell Value
remove rows based on values3

This post will guide you how to use the Find & Replace feature to delete or remove all rows based on certain cell value in Microsoft Excel. Or how to delete all rows that contain certain value with VBA code ...

How to Add Prefix or suffix to Cell
add prefix to cell113

This post will guide you how to add common prefix or suffix to all cells or the range of cells in your worksheet in Excel. How do I add the same prefix or suffix to a range of cells without ...

Quickly Insert Multiple Rows or Columns in Excel
insert multiple rows or columns13

This post will guide you how to quickly insert multiple rows or columns in your Microsoft worksheet. You will see that how to add new multiple rows or columns with shortcut or insert feature, or insert copied cells in excel. ...

Split Excel workbook into separate Files
split workbook into separate file3

This post will guide you how to split a large workbook to separate files and each worksheet should be saved as a single file. How do I split the whole workbook into several excel worksheets or single excel file. Assuming ...

How to Get the List of File Names From a Folder
get list of file names from a folder11

This post will teach you how to get the list of file names in a given directory to a worksheet in Excel. You will learn that how to use Excel to view Files and Folders in your worksheet by get ...

Find Duplicate Values in Two Columns
find duplicate cells in two columns111

This tutorial will show you how to find duplicate values in two given columns in Excel. Or How to compare two columns and find duplicate entries in Microsoft Excel worksheet. And you will learn two methods to compare columns so ...

Remove Leading and Trailing Spaces
remove leading and trailing spaces112

In this tutorial you will learn that how to remove leading or trailing spaces from a text string in a cell in Excel. This post will guide you how to delete leading or trailing spaces of all cells in a ...

Generate Random Passwords
generate random passwords5

This post will teach you how to quickly generate a random password with Formula in Excel. You can combine a series of worksheet functions to create a complex formula to generate a random password in Microsoft Excel. Generate Random Password ...

Sort by Second or Third character in a Column
sort string by second character13

This post will guide you how to sort text string by second or third character in a Column in Excel. You may be want to sort a string in a Cell by the Second or last character in excel, how ...

Copy a Cell to Clipboard with Single Click
copy a cell to clipboard3

This post will teach you how to use the Excel VBA macro code to copy a Cell to clipboard with only single click in Excel. How do I automatically copy the content of cell to Clipboard while clicking on the ...

Sidebar