How to Make Text Invisible in Excel?

To hide some calculations and to make the template look as desired with required output we need  make text invisible. We have two ways of making text invisible.

Making text font color to White .

Making text invisible using Number Format.


Suppose you have data with drop downs in column D for

Dept No, containing source from column E as below:

Text visible in column E.                                                  Text invisible in column E

Select the cells E1 to E10 which have to be made invisible. Select Font Color from Home menu.

Select White Background from Theme Colors.

Now the text in the cells E1 to E10 is invisible.

Suppose the data in

column D is linked with the data in column E as shown below:

Here we want to make column E invisible.

Select cells E2 to E8 which have to be made invisible. Select Number Format from Home Menu.

Select More Number Formats from the menu.

Select Custom and enter ’;;;’ in the Type.

Click OK.

The data in the column E is invisible.

———————————————————————————————————————————-

Vani is a Business Associate with p2w2, a Spreadsheet Solutions company. p2w2 has expertise in Excel Modeling, Excel Dashboards, Profitability Analysis,  Excel Invoices and Excel Bid sheets. You can contact us by email: cs [at] p2w2.com or call us at 305.600.0950.

How to Remove Duplicates Using Advance Filter?

Removing duplicates is one of the important tasks, when we work with database in excel. Many times you encounter a situation where you need to remove duplicate records/data. In the following article we tried explaining you ‘How to remove duplicates using Advanced Filter’, hope this articles helps you!

Data before removing duplicates.

advanced filter

Data after removing duplicates.

advanced filter in excel

Let us follow step by step process for removing duplicates using Advanced Filter.

Select a cell in your data set and choose Data from menu.
Select Filter and select Advanced from Sort and Filter group.

advance filter excel


Advanced Filter dialogue box appears.

excel advanced filters

Enter the range of data containing duplicates in the box provided for List range.

Here the List range is ‘$B$3:$C$16’.

Check the box Unique Records Only and click OK.
advanced filtering in excel
advanced filtering in excel

Excel removes duplicates and provide

you a unique list of records.

————————————————————————————————————–

Vani is a Business Associate with p2w2, a Spreadsheet Solutions company. p2w2 has expertise in Excel Modeling, Excel Dashboards, Profitability Analysis,  Excel Invoices and Excel Bid sheets. You can contact us by email: cs [at] p2w2.com or call us at 305.600.0950.