Home » Tag Archives: Microsoft Excel

Tag Archives: Microsoft Excel

How to set a password protection to excel spread sheet

X protection to excel spread sheet

To encrypt your workbook and set a password to open it: Click the Microsoft Office Button , point to Prepare, and then click Encrypt Document. In the Password box, type a password, and then click OK. You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help ...

Read More »

Remove or Delete Duplicate Rows in Microsoft Excel

microsoft is a wonderful office tool for all type of data related operations. Lot of data options are available. For remove a particular column data duplicates use the following method. 1. select the column 2.Press on data tab of microsoft excel 3.Can see a command “remove dupliactes”. Also we can use advanced command in the filter and sort group on ...

Read More »