Excel Tricks

In this article, I will tell you how to insert/delete a cell, row, or column in an excel worksheet. It will also tell you how to remove the cell content without moving the cell position.

When you input a number in an excel cell and if the number needs to start with 0, you will find excel will remove all the zeros at the beginning of the number. In this article, I will tell you how to put 0 in excel in front of numbers with several methods.

This article will tell you how to add an empty option in the excel data validation drop-down list. There are 2 methods to implement this, I will show them with examples.

When you process an excel table, sometimes you may want to sort the rows by each column value in the row. This article will tell you how to implement it.

This article will tell you how to transpose excel table rows and columns with menus or formulas. Then you can create another excel table based on the transposed rows and columns.

In this article, I will tell you how to copy one cell value or a cell range value to another cell or another cell range using a formula with examples.

In the previous articles, we told you how to use excel formulas and VBA to count unique and distinct values in excel. In this article, I will tell you about another method that uses a pivot table to count distinct value in the excel cell range.

This article will tell you how to hide or show gridlines in an excel worksheet both manually and using VBA. It will also tell you how to show or hide the gridlines when printing the excel worksheet.