find, select and print

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

Guest

I have a search for a word on a spreadsheet in Excel 2003. The results are
perfect. Now I would like to select all data in each row that contains the
word. Once the rows of data are selected I would like to print just that
data. The good news is that I can find with no trouble, but how can I select
the entire row not just the cells that hold the results of my search. Then,
how do I print the rows of data so the results end up on 1 page instead of
just 1 row per printed page?

Thanks for the help and have a great day.
 
Have you considered filtering your data? (Data>Filter>Autofilter) Once
filtered, you can select all rows with a particular word then print
everything as you described. This assumes that the word you seek is in a
cell of it's own (your question doesn't actually say)
 
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

Print Landscape/Portrait based on level of grouped data selected 4
Print Titles: Repeating both left column and top rows 2
I trying to develop a macro to print my worksheets 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
printing selection 2
Excel print area which only prints pages of worksheet which are active 0
Select Subset of Rows/Cols 1
SELECT ALL ROWS IF FIND 2

Back
Top