For over three decades, Microsoft has offered Excel, an excellent solution for creating simple spreadsheets and calculating complex formulas and functions. In addition to its vast functionality, another benefit of Excel spreadsheets is that you can create and use macros to automate any process or task. We’ll show you how to enable macros in Excel.Enabling Excel macros: How to activate these practical scripts
There are plenty of good reasons for saving an Excel file as read only. Excel spreadsheets often contain sensitive information such as numbers, formulas, and calculations. An accidental click in the wrong field or an incorrect entry can quickly lead to false results and mess up entire tables. When you make Excel read only, the file’s contents cannot be manipulated or accidentally edited.
Excel read only should not be confused with the encryption of Excel files: encrypted Excel files offer additional password protection to prevent unauthorized access.
In the following sections, we’ll show you the advantages of activating read only in Microsoft's spreadsheet program and how you can make an Excel file read only in just a few steps.
$1 Domain Names
Register great TLDs for less than $1 for the first year.
Why wait? Grab your favorite domain name today!
Why and how can you make an Excel file read only?
Complex Excel spreadsheets usually contain a lot of important data linked by formulas and calculations. By saving an Excel table as read only, you automatically prevent unwanted changes to the content. Saving a spreadsheet in this manner is useful for sharing it with colleagues or external clients because at that stage you’ll probably want to avoid it being manipulated or accidentally edited. But even for your own purposes (e.g., for final calculations) making files in Excel read only can be useful.
By adding password protection to your read only Excel file, you control whether changes to your Excel table are permitted and who gets to make them (by sharing the password). It’s just as easy to remove Excel read only if you want to enable editing of your table again. The process is similar to removing read only for individual Excel worksheets or unlocking a Word document for editing.
Prefer all of your Office applications including Excel to be up to date? No problem! With Microsoft 365 from IONOS you get the complete Microsoft Office Service with additional storage space for up to five devices per user!
How to make an Excel sheet read only (using a password): a step-by-step guide
Saving an Excel file as read only is quick and simple. Just follow the steps below to activate it.
The instructions are valid for Windows 10 and Excel 2019, 2016, 2013, and the Excel edition of Microsoft 365.
Step 1: Launch the Excel file you want to make read only. Go to the “File” tab and select the “Save As” menu item to open the options window.
Step 2: In the “Save As” window, click the “Tools” button to the left of the Save button. A small context menu will launch from which you can select the item “General Options”.
Step 3: Enter the password of your choice in the “Password to modify” field. This can be any word or key combination; it doesn’t need to meet any specific criteria. Check the box next to “Read-only recommended” to inform other users that the file is now read only when they open it. Beware: you’ll need the password to make changes to your Excel file in the future, so keep it safe!
Step 4: Excel will prompt you to reenter your password (“Confirm Password”). Repeating a password ensures that you haven’t made a mistake in the previous entry. Click “OK” to close the window.
Step 5: Click “Save” to activate read only in Excel.
Simplify working in Excel by using Excel shortcuts.
How to make an Excel document read only (without a password)
Prefer to add a note to your Excel spreadsheet that recommends users view it in read only rather than normal mode? You can recommend read only mode without setting a password. Simply follow steps 1 to 3 above without specifying “Password to modify” and add a checkmark next to “Read-only recommended”. Users will now receive a notification when opening the file.
How to open a read only Excel file with a password?
When you open a read only Excel file, the program may prompt you to enter the correct password. The following dialog window will pop up in which you can enter your password:
Professional Email Address & Personal Domain Name
Get an email address as professional and unique as you are including a free matching domain!
You’ve now got two more options:
- You know the password: Enter the password and click “OK”. If “Read-only recommended” has been activated, a second dialog window appears in which you can choose to open the file in read only mode or not. Click “Yes” and the file will open in read only mode. You’ll need to enter the password again to make changes to the document. If you click on “No”, the file will open in standard editing mode, and you can modify the file as per usual and save it without entering another password.
- You don’t know the password: Leave the password field empty and click on “Read only”. You can now view the file in read only mode but won’t be able to modify it.
Having trouble running Excel? Our guide tells you what you can do when Excel isn’t working.