Excel - Opening a Workbook as Read-Only

There may be times when you want to open a workbook as read-only. 

This means you will not be able to save any changes to the workbook you are loading. 

You can use the Save As option from the File menu in order to save the workbook using a different filename, however. 

Opening a workbook as read-only is self-insurance so you don't inadvertently mess up your file. To open a workbook as read-only, follow these steps:

1. Press Ctrl+O to display the Open dialog box. (In Excel 2013 you'll need to not only press Ctrl+O, but then click Computer and then Browse.)
2. Locate the workbook you want to open and then click once on the filename.
3. Click the down-arrow at the right side of the Open button. Excel displays a list of different ways you can open the workbook.
4. Choose Open Read-Only from the options in the drop-down list.

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London