I'm lost!

CAPT.PT · Mar 15th, 2002, 11:48 AM

I want to print only the "ROWS" that contain information.... any suggestions...When I go to DATA...click on "FILTER"..."AUTOFILTER"...
Nothing happens but a check mark is put by Autofilter....then what do I do??
Is it possible to print only rows with info on them???

PLEASE HELP!
THANK YOU

Von Pookie · Mar 15th, 2002, 11:53 AM

If you look a little more closely, you should have a drop down arrow in each cell with data in it on the top row.

For example, I have a worksheet in which I keep track of shipments that were made. In the first column, I have the date. So, if I want to see all of the items shipped on a certain date, I just click on the arrow, select the date I want from the list, and it will show everything on that date.

This works for all of the columns.

Mar 15th, 2002, 11:53 AM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	If you look a little more closely, you should have a drop down arrow in each cell with data in it on the top row. For example, I have a worksheet in which I keep track of shipments that were made. In the first column, I have the date. So, if I want to see all of the items shipped on a certain date, I just click on the arrow, select the date I want from the list, and it will show everything on that date. This works for all of the columns. __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 11:48 AM	#1
CAPT.PT New Member Join Date: Mar 2002 Posts: 32	I want to print only the "ROWS" that contain information.... any suggestions...When I go to DATA...click on "FILTER"..."AUTOFILTER"... Nothing happens but a check mark is put by Autofilter....then what do I do?? Is it possible to print only rows with info on them??? PLEASE HELP! THANK YOU