In this article, we will learn how to remove data restrictions applied on a cell of a worksheet. Many times we encounter an error saying “The value you entered is not valid. A user has restricted values that can be entered into this cell.” This is because, the worksheet designer ... Read More

When we work on multiple excel files, almost all excel application has a feature of keeping last few opened files in history. The list get displayed in Recent Pane whenever we open an excel file to quickly access any of those files without searching into machine. Sometimes we need to ... Read More

In this article we will learn how to update the pivot table data after updating the details of source table. In many cases, whenever we update the source data as per the requirement the old data still appears in the filter of pivot table dropdown options. This may create confusion ... Read More

In this article we will learn to remove filters while opening/closing or saving a worksheet. Because whenever a filter is applied in the worksheet it gets saved along with the file and remain as is until manually removed. They filters may be misinterpreted as missing data in the worksheet. The ... Read More

There are cases when we need to compare multiple sheets for consolidating the data in a single sheet against similar entries. Manually this task may need huge manpower as well as time. On the other side the same data can be consolidated by using a one or two formulas and ... Read More

If we have a huge data where hyperlinks have been scattered throughout the worksheet, then it becomes a tedious task to find the hyperlinks and external references. This tutorial will help a user to find the hyperlinks available in a worksheet in the following scenarios − Find all the ... Read More

Excel has a bunch of formulas and data analysts use this application to prepare various reports and dashboards. To support that analysis this article will help an excel user to identify all the cells whose values either starts with a number or an alphabet from a collection of dataset. We ... Read More

If we have a dataset in which we need to check if there are any cell values or text which is not required or inappropriate, then the same can be identified in seconds using an excel function. There are many functions through which we can identify specific set of text ... Read More

When we have a list of entries in excel file and need to identify if there are some entities starting with a specific letter of special character, then looking at each value and counting will be a tedious task to do. This article will help you to find those entities ... Read More