How do you save an Excel File that is read only?

How do you save an Excel File that is read only?

Save a workbook as read-only

  1. Open the workbook, and click File > Save As (> Browse).
  2. In the Save As dialog box, please click Tools > General Options.
  3. In the General Options dialog box, please check the Read-only recommended option, and click the OK button.
  4. Click the Save button in the Save As dialog box.

How do you protect a workbook in Excel 2010 but allow read only?

How to Save an Excel Workbook as Read Only

  1. The “Save As” dialogue box will pop up.
  2. Doing so will open the “General Options” dialogue box.
  3. You’ll be prompted to confirm the password.
  4. Clicking the “Read-Only” button will open the document but in Read-Only mode.

How do you make an Excel document not editable?

Protect a sheet

  1. Select Review > Manage Protection.
  2. To turn on protection, in the Manage Protection task pane, select Protect sheet.
  3. By default, the entire sheet is locked and protected.
  4. Optionally, to require a password to edit a range, select Range password, enter and confirm the password, and then select Save.

How do you make a File read only?

GUI Method. Right click on the file, you want to make it Read-only. Click on the Properties tab from the context menu. Click the Read-only check box belong to Attributes from on the General tab from the popped up Properties window.

How can I make a spreadsheet read only for others?

You can have Excel make a spreadsheet in read only format for others, so that people can read its contents but not edit them, or you can enforce other content restrictions. To do so, click the “File” tab in the ribbon menu, then click “Info.” Then, click “Protect Document” and choose one of the options presented.

How do you make a file not editable?

To make a document un-editable, first, select all the text in the document by pressing Ctrl+A. Once all of the text is highlighted, click “Restrict Editing” in the “Protect” group on the “Developer” tab.

How do I make a text file not editable?

How do I make a file read only?

To make a file read only is just as simple: check the Read-only box in the file’s Properties window. Right-click the file, go to Properties in the menu that pops up, and then select Read-only at the bottom of the General tab.

How do I save a file as read only?

Save as read only

  1. Click the Microsoft Office Button. , and then click Save or Save As if you have previously saved the document.
  2. Click Tools.
  3. Click General Options.
  4. Click the Read-only recommended check box.
  5. Click OK.
  6. Save the document.

How do you make an Excel workbook read only for others?

Read-only Workbook

  1. Click on the Tools button and click General Options.
  2. In the Password to modify box, enter a password and click OK.
  3. Note: If you only want to recommend users to open the Excel file as read-only, without protecting it, don’t enter a password and check Read-only recommended.

How to change Excel from read only?

Download and install a Cocosenor Workbook Unprotect Tuner tool on the computer.

  • Click on the ‘Open button to open the Workbook Unprotect Tuner,import the program by selecting the Excel file.
  • Click on the Remove Password button.
  • A notification stating that the read-only password has been removed appears after 2 seconds.

    • How do you make an Excel file read only?

    Click Review > Restrict Editing.

  • Under Editing restrictions,check Allow only this type of editing in the document,and make sure the list says No changes (Read only).
  • Click Yes,Start Enforcing Protection.
  • In the box that opens,type a password you’ll be able to remember,and then type the password again to confirm it. The password’s optional.

    • How to make an Excel file read only?

    Open the Excel File you want to encrypt,like any other Excel file.

  • Open ‘’Save As” dialog box from top file menu,a tool dropdown will appear near “Save As” button.
  • Open the dropdown and choose “General Options”,it will show some other settings.
  • Now,check “Read-only Recommended” and optionally you can also set password if you want.

    • How do you open read only in Excel?

    – Select Open from the File menu, or click on the Open tool on the toolbar. You will see the Open dialog box. – Locate the workbook you want to open and then click once on the filename. – Click on the Commands and Settings button. – Choose Open Read Only from the Context menu.