Applying Filter to Check a Shared Worksheet

A worksheet that was being accessed and updated by different users, especially of different departments or teams, may contain some differences in format like letter case of the words, font and size. Working in a worksheet of this kind should be done with a lot of caution as there are some functions in Excel that has some limitations or effects to the worksheet that some users may not notice.

With the objective of making the format standard for the data for a worksheet that has been updated by different users may be a lot of work. With our knowledge in excel we know that there are functions that we can use to make the checking and editing easier. But one of the most common functions used to check large amount of data in a column may not be the best option.

Doing the filter with just placing the cursor with top most part of the data, usually the first header, without checking if there are blanks or not highlighting the whole data has a big effect in checking the whole data.

Such effects are as follows:

1. After clicking the arrow on the filtered header all the data within the filtered area will be reflected in ascending order. In the image below the first name in the data is “Flor”, it means Akira who should have been first in the list was not included in the filter.
2. Filter is not case sensitive. Based on the filtered data shown all the names are in the correct capitalization, the first letter is in capital, including the name Michael. When you will look closely at the data there are three Michael in the list. The first Michael is in the correct form but the other 2 are not.