Excel Tips and Tricks

 In todays high speed and competitive world one need to take quick and accurate decisions. Gathering, filtering and analyzing raw data has b...

Here are the cells with comments I want to search.   The data range here is small, so you can search each comment manually by pointing yo...

Today I am going to show you how to delete/debug all unwanted errors in worksheet in just few steps: 1. Make sure that you group/hide c...

1. To move right end of data range type Ctrl + Right Arrow Key (->) 2. To move left end of data range type Ctrl + Left Arrow Key (<-...

1. To rename the current sheet type Atl + O + H + R 2. To insert new worksheet type Shift + F11 3. To move or copy the current sheet Alt + ...

There is a simple shorcut for dividing/multipling/adding/subtracting any cell value with a factor. Lets me illustrate. We have following dat...

Sometimes we receive data which is running horizontally for given year. It is difficult to interpreted data and linking in another workbook/...