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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
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

V
  • Question
Excel VBA - How to modify my code to include a command that prints data to PDF
Replies
1
Views
66
VanGirl
V
A
  • Question
VBA Autofilter IF the criteria does not existing
Replies
6
Views
269
Alexsay
A
B
  • Question
VBA code to cut and paste multiple filtered rows based on multiple criteria
Replies
2
Views
497
Alex Blakenburg
A
K
  • Solved
help with 'no cells found' error... (ideas on how to get around this...)
Replies
3
Views
187
Alex Blakenburg
A
F
  • Solved
Replacing multiple instances of text file lines
Replies
2
Views
84
frateg8r
F

Forum statistics

Threads
1,215,008
Messages
6,122,672
Members
449,091
Latest member
peppernaut

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