![]() To print the filtered data, we have to put the filter in data Column A contains Date, column B contains Agent name and column C contain Revenue amount. Let’s take an example to understand how we can print a filtered list. Shortcut Key:- Press Ctrl+Shift+L on your keyboard. This option is available in the Data Tab under the Sort & Filter group. Even we can sort the data as per the number, text, cell colors, and font colors, etc. We can filter the data according to the particular text, month, date, number, cell color, font color, etc. To Printing a filtered list, we will use the Auto filter option and Print option in Microsoft Excel 2010.Īuto Filter: - This option allows us to filter the data based on content of cells and conditions applied on them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |