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

How to Use the data Validation Input Message as a Cell Comment in Excel

In this article, we will learn How to Use the data Validation Input Message as a Cell Comment in Excel. Scenario: Data Validation is the too...

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

Hide/Unhide a Sheet in Excel 2007

In this article, we will learn how to hide and unhide the sheet in Microsoft Excel 2007. We hide the sheet when we do not want to show the sheet to s...

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.