Excel 2013: Finalizing and Protecting Workbooks

Lesson 25: Finalizing and Protecting Workbooks

/en/excel2013/track-changes-and-comments/content/

Introduction

Before sharing a workbook, you'll want to make sure it doesn't include any spelling errors or information you want to keep private. Fortunately, Excel includes several tools to help finalize and protect your workbook, including Spell Check and the Document Inspector


Optional: Download our practice workbook.

To use Spell Check:

  1. From the Review tab, click the Spelling command.
    Screenshot of Excel 2013Clicking the Spelling command
  2. The Spelling dialog box will appear. For each spelling error in your worksheet, Spell Check will try to offer suggestions for the correct spelling. Choose a suggestion, then click Change to correct the error.


    Screenshot of Excel 2013Using Spell Check to correct spelling errors
  3. A dialog box will appear after reviewing all spelling errors. Click OK to close Spell Check.
    Screenshot of Excel 2013Closing Spell Check

If there are no appropriate suggestions, you can also enter the correct spelling manually.

Ignoring spelling "errors"

Spell Check isn't always correct. It will sometimes mark certain words as incorrect, even if they're spelled correctly. This often happens with names, which may not be in the dictionary. You can choose not to change a spelling "error" using one of three options:

  • Ignore Once: This will skip the word without changing it.
  • Ignore All: This will skip the word without changing it and also skip all other instances of the word in your worksheet.
  • Add: This adds the word to the dictionary so it will never appear as an error again. Make sure the word is spelled correctly before choosing this option.

Document Inspector

Whenever you create or edit a workbook, certain personal information may be added to the file automatically. You can use the Document Inspector to remove this kind of information before sharing a workbook with others.

Because some changes may be permanent, it's a good idea to save an additional copy of your workbook before using the Document Inspector to remove information.

To use the Document Inspector:

  1. Click the File tab to access Backstage view.
  2. From the Info pane, click Check for Issues, then select Inspect Document from the drop-down menu.
    Screenshot of Excel 2013Clicking Inspect Document
  3. The Document Inspector will appear. Check or uncheck boxes, depending on the content you want to review, then click Inspect. In our example, we'll leave everything selected.
    Screenshot of Excel 2013Inspecting the workbook
  4. The inspection results will appear. In our example, we can see that our workbook contains some personal information, so we'll click Remove All to remove that information from the workbook.
    Screenshot of Excel 2013Removing personal information from the workbook
  5. When you're done, click Close.
    Screenshot of Excel 2013Closing the Document Inspector

Protecting your workbook

By default, anyone with access to your workbook will be able to open, copy, and edit its content unless you protect it. There are many different ways to protect a workbook, depending on your needs.

To protect your workbook:

  1. Click the File tab to access Backstage view.
  2. From the Info pane, click the Protect Workbook command.
  3. In the drop-down menu, choose the option that best suits your needs. In our example, we'll select Mark as Final. Marking your workbook as final is a good way to discourage others from editing the workbook, while the other options give you even more control if needed.
    Screenshot of Excel 2013Selecting Mark as Final
  4. A dialog box will appear, prompting you to save. Click OK.


    Screenshot of Excel 2013Clicking OK to save the workbook
  5. Another dialog box will appear. Click OK.
    Screenshot of Excel 2013Clicking OK
  6. The workbook will be marked as final.


    Screenshot of Excel 2013A workbook marked as final

Marking a workbook as final will not prevent someone from editing it. If you want to prevent people from editing it, you can use the Restrict Access option instead.

Challenge!

  1. Open an existing Excel workbook. If you want, you can use our practice workbook.
  2. Run the Spell Check to correct any spelling errors in the workbook.
  3. Use the Document Inspector to check the workbook. If you are using the example, remove all personal information from the workbook.
  4. Protect the workbook by marking it as final.

/en/excel2013/conditional-formatting/content/