Excel File Protection

Excel File Protection

As followup to my previous article, there are many forms of protection to the workbook/Excel File, like mark document as final, open as read only, encrypt with password ,restrict access & add a digital signature etc,

Restrict access will allow certain people which you choose who can edit/modify the contents, its pretty similar to protect sheet which i discussed in previous article

Digital signature, its like regular signature (which we used to do by hand) but encrypted, to ensure that the file sent was not modified by some third party or hackers, that is ensure authenticity

The ones that I use frequently is mark the document as final & then encrypt with password

Mark the document as final is a feature that lets your users know that the document is final & it will notify them before they can make any editing

No alt text provided for this image

To mark your document as final, just go to files, then info then protect workbook & you will see mark as final, then press it & excel will ask you to save your file again

No alt text provided for this image

If you are very worried about the contents of the file, you can protect the workbook with a password (you cant view it without a password), to do that go to file->info->protect workbook-> encrypt with password, enter your password twice & thats it, now each time you open this file, you need to enter password to view its contents

Please note that these features apply to all office products word, excel & powerpoint

要查看或添加评论,请登录

Chahine Atallah的更多文章

  • Protect Specific Ranges in Excel

    Protect Specific Ranges in Excel

    Assume you have one Excel file & multiple users are updating this file, but each user has to update his fields/cells…

    1 条评论
  • Protecting your worksheets & Workbooks

    Protecting your worksheets & Workbooks

    How to protect worksheets properly? first there is a difference between protecting worksheets & protecting workbooks…

  • Custom formatting in excel (few guidlines)

    Custom formatting in excel (few guidlines)

    Do you know about custom formatting in excel, for example positive numbers to be green, negative numbers in red , zeros…

  • Convert Function

    Convert Function

    Did you ever want to convert from one unit to a different one There is a ready-made excel function called convert, you…

  • Dynamic Arrays (Filter Function)

    Dynamic Arrays (Filter Function)

    Most of our time in excel we use Filter & Sort, but the conventional filter in excel has some limitations , "or"…

  • Pivot Table Tips

    Pivot Table Tips

    Pivot tables one of the most useful feature in excel , ill share some useful tips which might be beneficial to you…

    1 条评论
  • Aggregate Function

    Aggregate Function

    One of the cool functions in Excel is the aggregate function, actually it includes many functions (19 functions ) in…

  • Counting Blank Cells

    Counting Blank Cells

    How do you usually count blank cells in excel? i think most use the count blank function, but there is one issue in…

    1 条评论
  • Flash Fill in Excel

    Flash Fill in Excel

    We have Got times when we need to extract specific data from certain columns, usually we do it either by using "split…

    2 条评论
  • The XLOOKUP Function

    The XLOOKUP Function

    Many excel users face a problem when extracting data when using VLOOKUP /HLOOKUP Functions, as these functions have the…

社区洞察

其他会员也浏览了