I'm lost!

C

CAPT.PT

New Member
Joined
Mar 2, 2002
Messages
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
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
VBA Autofilter IF the criteria does not existing
Replies
6
Views
266
Alexsay
A
B
  • Question
VBA code to cut and paste multiple filtered rows based on multiple criteria
Replies
2
Views
477
Alex Blakenburg
A
K
  • Solved
help with 'no cells found' error... (ideas on how to get around this...)
Replies
3
Views
177
Alex Blakenburg
A
D
  • Question
Random selection modification not working
Replies
2
Views
153
Damian37
D
T
  • Solved
=IF Formula Question
Replies
5
Views
259
Fluff
Fluff

Forum statistics

Threads
1,214,789
Messages
6,121,590
Members
449,039
Latest member
Arbind kumar

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top