How to enable auto filter for protected sheet in Excel

We had already seen the following tutorials related with protection of worksheet in Excel 2016, 2013 & 2010. Prevent users from adding new worksheet. Password Protect Worksheet in Excel. Unprotect Worksheet in Excel. And if a worksheet with auto filter is protected then users will not be able to use auto filter unless it is […]

How to enable a disabled add-in in Excel 2010

Office products such as Word, Excel Outlook will automatically disable installed add-in if any add-in prevented the software from functioning correctly. And it also provides option for enabling the disabled add-in items. In Excel 2010 you can enable a disabled add-in using the add-in options. Click the File menu –> Options link –> Navigate to […]

How to enable autocomplete in Google Docs Spreadsheet

Autocomplete feature helps users by automatically filling the content of cell when users starting entering the first couple of letters in the Cell. The automatic entry is picked from the previously entered values for the same column. Let us say you have got the following list of entries in one of the column Arizona Alabama […]