How do I print a Find-all search in Excel 2002?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There are many occassions when I search my spreadsheet for multiple occurence
of a particular number using the "Find All" search request. I then have to
write the cell references down - (this is a record of multiple payments by
the way). Is ther any way to print out the search results?
 
if they are all in one column, try <data><filters><autofilter>
if they are in several columns, the advanced filter may work it is just a
little more complex.
 
Can you get the records you need by using a filter? You can then print out
the filtered subset
 
Hi Pughy. Not very elegant, but once you have identified the multiple
numbers in the find all screen, hold the alt key and press PrtScr. This puts
the active dialog box on the clip board. TheN press paste, select the print
screen object and print it. HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching and counting text in a spreadsheet 3
How do I remove extra blank lines in a column when I print? 2
Alt codes 4
Problem printing all worksheets in colour 1
How do I search multiple worksheets silmutaneously in Excel? 4
Find a number in Excel file using search 5
making a cell a search/find field 5
Search for text (across multiple worksheets) in Excel 2007? 1

Back
Top