To Printing a filtered list, we will use the Auto filter option and Print option in Microsoft Excel 2010.
Auto Filter: – This option allows us to filter the data based on content of cells and conditions applied on them.
We can filter the data according to the particular text, month, date, number, cell color, font color, etc. Even we can sort the data as per the number, text, cell colors, and font colors, etc.
This option is available in the Data Tab under the Sort & Filter group.
Shortcut Key:- Press Ctrl+Shift+L on your keyboard.
Let’s take an example to understand how we can print a filtered list.
We have data in range A1:C18. Column A contains Date, column B contains Agent name and column C contain Revenue amount.
To print the filtered data, we have to put the filter in data
Follow below given steps:-
To print the filtered area, follow below given steps:-
This is the way we can print a filtered list in Microsoft Excel.
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.