How To Prevent From Entering Space Before or After Text Using Data Validation In Microsoft Excel

To prevent user from entering space before text, you can make use of Data Validation feature in Microsoft Excel. This will be helpful for users whi...

How To Perform Multi Level Data Sorting In Microsoft Excel 2010

Data sorting is a daily activity which is required to perform to make data easier to read. If you have large data sets & you want to perform multi...

How To Highlight Row And Column Of Selected Cell Using VBA In Microsoft Excel 2010

In this article, you will learn how to highlight row & column of selected cell.   Click on Developer tab From Code group, select Vis...

How To Get Row Number By A Single Click Using VBA In Microsoft Excel 2010

In this article, you will learn how to get row number by a single click.   Click on Developer tab From Code group, select Visual Basic &n...

How To Find The Next Row in VBA Microsoft Excel 2010

Finding the next row means finding the last used row +1. Finding the last used row or column is one of the basic and important tasks for any autom...

How To Find The Last Used Cell in a Row in Microsoft Excel 2010

In this article, we will learn How To Find The Last Used Cell in a Row in Microsoft Excel 2010. Scenario: In simple words, while working with lo...

How To Find The Last Used Cell in One Column in Microsoft Excel 2010

In this article, we will learn How To Find The Last Used Cell in One Column in Microsoft Excel 2010. Scenario: In simple words, while workin...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.