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...

Clearing cells

Clearing cells can be a drag sometimes. You can also use the Fill Handle to clear the contents of a range of cells by dragging it backwards over the c...

Completing partially-filled data

I came across this tip years ago and remember being amazed by it at the time (although now it's just part of my repertoire). Often you come across ...

Identifying all the merged cells

It often becomes necessary to get rid off merged cells and then it is very tedious and time consuming task to go and select each merged cell and then ...

Using the Validation Input Message as a Cell Comment in Excel 2007

To use the Validation Input Message as a cell Comment: 1. Select Data - Data Validation (in Data Tools Group). 2. Select the Input Message tab. 3...

Deleting a Comment(s) in a Sheet in Excel 2007

To delete a Comment: Select a cell contains a comment, select Review - Delete (in Comments Group). Or Right-click and select Delete Comment from ...

Reviewing Comments in the Sheet in Excel 2007

To review each comment in the sheet: Select Review - Next or Previous (in Comments Group). To review all the comments in the sheet: Select R...

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube