How do I print selected lines from a worksheet

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

Guest

I have a worksheet with several hundred lines of info. I want to select 8
lines that are spread within 50 lines...how do I print just those 8 lines?
 
I assume the 8 lines are together. If so, then highlight the lines you want
to print. Click on FILE (menu bar), then PRINT AREA, then SET PRINT AREA.
Then click PRINT.

If the 8 lines are not together, I am not sure what will work. I do not
that you can highlight items (lines) that are not together by holding the
CNTRL key down and then highlight the specific lines you want. However, I am
not sure how it would work when you print it. The computer I am on right now
does not have a printer so I cannot test it. Anyway, be sure to follow the
directions to SET PRINT AREA after highlighting.

Good Luck,
 
Hi

One way is to use an empty column and mark each line with an x and then
Filter/Autofilter on the x.

Andy.
 

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

Sort each line horizontally and separately 2
ASAP HELP..if formula is false how do i get it to go to next line 6
move a row of data from one work sheet to another using a formula 1
Worksheet + 1 1
sort 2
Word to Excel: Export comments with text and line number 0
Manipulating matrices of unknwon (a priori) size 1
How can print A Id badge From a Excell Work Sheet 3

Back
Top