Many students mentioned that Excel is very effective for the storage of a great number of facts and for the generation of constructed data tables and figures. However, most of the time, you do not want to share some of this information to other people because these may contain sensitive information.
In that case all you can do is mask excel data in several ways. In this article, you will learn how to redact in Excel. Therefore, instead of doing a search procedure that will take you all over the internet for answers to the query, can you redact in excel, you do not have to, we have got you fully covered with a guide that would get the job done in a blink of an eye.
Moving straight forward, here is a guide on how to do it and a bonus Excel redaction tool.
How To Redact in Excel by Blacking Out?
If you use Excel and need to cone and mask some data then you can always black out various cells. This format will keep your data privy and it will also be secure. Below are the right procedures that you can follow in order to blackout Excel data out.
1. If you wish to limit access to particular information, open the document and then choose the cell(s) you wish to obscure.
2. You can find it in the “Home” section, where there is the last icon on the right with the label “Format”.
3. Move the cursor to the right until you reach the bottom of the list by the orange name, click on “Format Cells.”
4. A new window will appear which window has options tab and the option “fill” click at “background” box and select black color.
5. Once this is done, click on the “File” and then “Save As” and eventually save it in Portable Document Format [PDF].
6. Now you can share it with others with selected information, information such as this.
How To Redact in Excel via Filter Tool?
In regards to the query whether can you redact in Excel using the filter button, then do not worry because you can. The only disadvantage is having to save the tables either as a new document after the filter has been carried out or as PDFs. Here are the essential steps.
1. When an Excel document is opened, in the “Home” menu find “Sort and Filter” button and click it then select “Filter” to bring out the filter.
2. Push on any button in the drop-down button at the first row and choose what item or items you would like to display or none, then click on OK.
3. After that, the filter sorts all the information, and either “Save as” another document or just ‘Print’ the document to PDF.
How To Redact in Excel with Document Inspector?
Regardless of which of the above methods you are presently using, when you save it in another form, information that is used as metadata still remain with it. When saving or printing as PDF it is acceptable, but whenever you share in excel, through document inspector you have to erase the metadata.
1. During generating a new structure for the Excel sheet when you are through with the work on them and ready to share, click on the “File” menu and select “Info”.
2. On the next step, which is marked by the picture below, please click on the “Document Inspector” menu. It is in this next step that you can click on “Inspect”.
3. When you write text, you can decide which data you want to delete or just click on the button “Clear all” to erase it before its sharing with other users.
