Add a New Comment in Microsoft Excel

In this article we will learn how we can add a new comment in Excel. Before we learn about how to add comments in a sheet, we have to understand abou...

How to get the Validation of Text Entries in Microsoft Excel

In this article, we will learn How to validate text entries in Microsoft Excel 2016. Data validation tool restricts the user to input data to ensur...

Using a Picture to Watch Cell Values in Other Sheets in Excel 2010

To use a picture to watch cell values in other sheets, we use the Camera tool in Microsoft Excel 2010. Camera Tool - Camera tool creates a mirror i...

Separate First and Last Names in Excel

To separate the first and the last name from a cell in Microsoft Excel, you can use a combination of a few functions. Use the “Left” function comb...

Searching for text in Microsoft Excel

In this article we will learn how we can search for specific text, numbers, and formulas in current worksheet and all worksheets of a workbook by usin...

Editing a formula using keyboard

In this article, you’ll learn how to edit a formula using keyboard in Microsoft Excel. Sometimes, you will find yourself clicking back and forth bet...

Toggle between edit and select mode for formulae

Many a times when we want to edit a formula and press the arrow key to move through the formula, we tend to select another cell and mess up the formul...

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.