Free Excel Tutorial for Engineers : Filter Feature



In excel when you have a long table, you might wish to work only on a subset of the data rather than on the whole table put together. The filter option in excel will enable this. The filter option allows you to select only the required cells and hides the other data. For using filter, select the columns go to the data ribbon at the top and select the filter option. The filter option also allows you to run multiple filters at a time and thus allows you to edit data faster. After the filters are activated you can also run custom filters. If you click on the drop down menu in the filtered column, you can select only the data that you want to be displayed from the list provided. You can also filter data based on what the value equals to or the value from which the data begins or ends with, or even by any part of the data contained within the cells.  Each of these filters can also be used in combination with each other by using the custom filters option. Like the sort option, the filter option also allows you to filter data according to the cell colour or the font colour. This option can be used through the right click facility.

16.png

End Functions: When we have lengthy worksheets it becomes very difficult to navigate quickly within the worksheet. There are a lot of keyboard shortcuts in excel which help you to navigate within a worksheet or select required cells using a few key strokes. Some of the most used shortcuts are listed in the table below:

Sl. No. KEY DESCRIPTION
1. Ctrl + Arrow key Allows you to navigate to the last non-blank cell of the row or column
2. Shift + Arrow key Allows you to select multiple cells one by one
3. Ctrl + Shift + Arrow key Allows you to select cells to the last non-blank cell of the row or column
4. Ctrl + End Allows you to navigate to the last non-blank cell of the worksheet
5. Ctrl + Shift + End Allows you to select all cells from the active cell to the last non-blank cell of the worksheet
6. Ctrl + Home Allows you to navigate to the first cell of the worksheet
7. Ctrl + Shift + Home Allows you to select data from the active cell to the first cell of the worksheet

Most of the options in the second and third chapters are explained using the mouse. But, it is important to know some of the basic keyboard shortcuts to speed up your work process. Listed below are a few of the standard keyboard shortcuts:

Sl. No. Key Description
1. Edit Button Opens the right click options on the worksheet
2. Ctrl + C Allows you to copy data to the clipboard
3. Ctrl + X Allows you to cut data to the clipboard
4. Ctrl + V Allows you to paste data into the worksheet from the clipboard
5. Ctrl + A Allows you to select all the data on your worksheet
6. Ctrl + S Allows you to save your workbook
7. Ctrl + Z Allows you to delete your last entry (undo)

Many other shortcut keys are mentioned at the end in the appendix.