Printing a Filtered List in Microsoft Excel 2010

 

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.
 
img1
 
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.
 
img2
 
To print the filtered data, we have to put the filter in data

Follow below given steps:-

  • Select the first cell of data.
  • Press the key Ctrl+Shift+L on your keyboard.

 
img3
 

  • If you want to put the data as per date.
  • Click on the filter with the mouse.
  • Drop down list will appear.

 
img4
 

  • Select any date from the list.

 
img5
 

  • Only selected date’s related data will appear.

To print the filtered area, follow below given steps:-

  • Select the appearing data.
  • Go to Page Layout tab, select Print Area in the Page Setup group.

 
img6
 
img7
 

  • From the drop down list, select Set Print Area.
  • To see the print preview, click on Print tiles in Page Setup group.

 
img8
 

  • Page Setup dialog box will appear.

 
img9
 

  • Click on the Print Preview.

 
img10
 

  • We can see only the filtered area is ready to print.

This is the way we can print a filtered list in Microsoft Excel.
 
 



2 thoughts on “Printing a Filtered List in Microsoft Excel 2010

  1. “Dear counciler I have a big stock of 8460 labels , and I have my price list on msn excel , and I want to print line a,c,e,g on a address label , and paste it on all my catalog picture s , excel help is very complicated , and does not explain this exact method, can you quote a method in excel, or from your help section to help me with this project thank You Peter Garcia
    949 492 3232 949 492 2273fx
    email garciaclassique@cox.net

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>