Pirtûkên xebatê yên li Excel-ê vekin û biparêzin

If you expect to share your Excel workbook with other users, then it makes sense to hide all personal and confidential information, check the document for errors, and protect the workbook in one of the possible ways. How to do all this, you will learn from this lesson.

Spellchecking

Before sharing an Excel workbook, it can be helpful to check it for spelling errors. I think many will agree that spelling errors in a document can drastically damage the author’s reputation.

  1. Li ser tabloya Pêşkeftî Çavdêriya di komê de Rastnivîs fermana çapemeniyê Rastnivîs.
  2. Qutiyek diyalogê dê xuya bibe Rastnivîs (in our case it is ). The spelling checker offers suggestions for correcting each spelling mistake. Select the appropriate option and then click the button Diberdasitin.Pirtûkên xebatê yên li Excel-ê vekin û biparêzin
  3. When the spell check is complete, a dialog box will appear. Click OK temam bikin.Pirtûkên xebatê yên li Excel-ê vekin û biparêzin

If there is no suitable option, you can correct the error yourself.

Missing errors

The spell checker in Excel does not always work correctly. Sometimes, even correctly spelled words are marked as misspelled. This often happens with words that are not in the dictionary. It is possible not to fix the incorrectly specified error using one of the three available options.

  • Hilperkîn – leaves the word unchanged.
  • Hemûyan derbas bikin – leaves the word unchanged, and skips it in all other occurrences in the workbook.
  • Add to dictionary – adds the word to the dictionary, so it will no longer be flagged as an error. Make sure the word is spelled correctly before choosing this option.

Çavdêriya Dokumentê

Some personal data may automatically appear in an Excel workbook. By using Çavdêriya Dokumentê you can find and delete this data before sharing the document.

Because the data deleted Çavdêriya Dokumentê is not always recoverable, we advise you to save an additional copy of the workbook before using this service.

How the Document Inspector works

  1. Click de Wêne, To move to dîmena paşperdeyê.
  2. Di komekê de îstîxbarata fermana çapemeniyê Li pirsgirêkan bigerin, and then from the drop-down menu, select Çavdêriya Dokumentê.Pirtûkên xebatê yên li Excel-ê vekin û biparêzin
  3. Dê vebe Çavdêriya Dokumentê. In the dialog box, select the appropriate checkboxes to select the types of content you want to check, and then click Berçavkirinî. In our example, we left all the items.Pirtûkên xebatê yên li Excel-ê vekin û biparêzin
  4. The test results should appear. In the figure below, you can see that the workbook contains some personal data. To delete this data, press the button her tiştî jêbirin.Pirtûkên xebatê yên li Excel-ê vekin û biparêzin
  5. Click when finished Nêzîkî.Pirtûkên xebatê yên li Excel-ê vekin û biparêzin

Workbook Protection

By default, anyone with access to your workbook can open, copy, and edit its contents, unless it is protected.

How to protect a book

  1. Click de Wêne, To move to dîmena paşperdeyê.
  2. Di komekê de îstîxbarata fermana çapemeniyê Pirtûka parastinê.
  3. Select the most appropriate option from the drop-down menu. In our example, we have chosen Wek dawî nîşan bikin. Kom Wek dawî nîşan bikin allows you to warn other users about the impossibility of making changes to this workbook. The remaining commands provide a higher degree of control and protection.Pirtûkên xebatê yên li Excel-ê vekin û biparêzin
  4. A reminder will appear that the book will be marked as final. Click OK, to save.Pirtûkên xebatê yên li Excel-ê vekin û biparêzin
  5. Another reminder will appear. Click OK.Pirtûkên xebatê yên li Excel-ê vekin û biparêzin
  6. Your workbook is now marked as final.Pirtûkên xebatê yên li Excel-ê vekin û biparêzin

Kom Wek dawî nîşan bikin cannot prevent other users from editing the book. If you want to prevent other users from editing the book, select the command Gihîştina sînor bikin.

Leave a Reply