Excel Tricks

Suppose you have an Excel workbook that contains multiple sheets with sensitive information, such as financial data, HR records, and customer lists. You want to share the workbook with a team of colleagues, but you only want them to be able to access certain ranges of cells within each sheet based on their roles and […]

In this article, I will tell you how to find number values formatted as text in excel cells, and how to convert the text formatted number to number format.

In this article, I will tell you how to use the excel data validation tool,  or a drop-down list, or a conditional formatting rule to avoid duplicates data entry.

When using Excel for data processing, selecting cells is a common operation. In this article, I will introduce some tricks of how to quickly select current data cells, adjacent and non-adjacent data cells, entire row and column, and the same cell range in multiple Excel worksheets.

In this article, I will tell you how to use the excel Data Validation tool, named range,  and INDIRECT function to implement cascade menus with examples, this feature is very useful when you are using excel.

When you operate an excel workbook, you may encounter some error texts such as #####, #DIV/O!, #N/A,  #NULL, #NUM!,  #REF!, #VALUE!. By understanding these common errors and knowing how to correct them, you can create more accurate and reliable spreadsheets in Excel. This article will tell you what does these error message means and how

This article will tell you how to split one excel worksheet data into multiple excel worksheets. It will also tell you how to split excel worksheet data set by column.

To view multiple worksheets simultaneously in Excel, you can follow the below steps introduced in this article.

Creating a mailing list in Gmail from an Excel sheet is a great way to quickly get your contacts into the Gmail system. In this article, I will tell you 2 methods to create a mailing list in Gmail from an Excel worksheet. One is done manually and the other is done automatically. You can

In this article, I will tell you how to remove duplicate rows in excel with two methods. The first method is using the excel advanced filter feature, this method can reserve the original datasets. The second method is to use excel’s remove duplicates menu, this method will remove the duplicate rows permanently.