How do I print multiple selected rows to a single sheet in Excel?

Question

At my work I have a large Excel file with about 700 rows of data. I usually need to print a selection of 4-10 of these rows a day. The rows are not consecutive.

Currently I ctrl-click the rows I need and then print->selection, but this makes every row print on a separate sheet of paper.

I am wondering if there is a simple way to have them all print onto a single sheet.

Thanks.

PS This is Excel 2010 and the file has a "header"(?) row, I guess you'd call it, as row number one (row 1 AND my selected row prints on each page).

Answer 1

Here is a way to print all selected rows on one page.



The following macro utilizes a worksheet named 'Print' to hold all selected rows. Change the four "Print" references to an unused worksheet name in your workbook, i.e. "Sheet3", etc. Or Insert a new worksheet and rename it 'Print'.



Then, copy the following macro, modified if necessary, to the clipboard:



Sub Extract_to_Print()

Range("A1").EntireRow.Copy Destination:= _

Sheets("Print").Range("A1")

For Each cell In Selection

cell.EntireRow.Copy Destination:= _

Sheets("Print").Range("A" & _

Rows.Count).End(xlUp).Offset(1, 0)

Next

Sheets("Print").PrintOut

Sheets("Print").Cells.ClearContents

End Sub



With your workbook open, press ALT + F11



In the menus at the top of the VBE, select INSERT > MODULE



Paste the macro into the editing area to the right.



Close the VBE and return to the worksheet.



Press ALT + F8



When the Macros window opens, highlight the macro and click 'Options..'



Enter a letter to be used as a keyboard shortcut and click 'OK'.



Save the workbook.



Select a range of rows that you wish to extract and print, by pressing Ctrl + click, as usual.



With the Ctrl key still depressed, simply press your shortcut letter.



That will extract the select list to the 'Print' worksheet, including the header row, print that worksheet, and clear the extracted data from the sheet. You could then select a different set of rows, call the macro, and print that list.

Answer 2

Click on the # of the row that you are selection. Hold down the Ctrl Key and click on the next # of the row that you want to section. Repeat this (while holding Ctrl) for all rows you want to select. Once they are all highlighted. Go to file ---> print ---> selection. Another way is to copy and paste them into a new book then printing the new book.

Answer 3

this could paintings. Create a clean column, positioned a a million in each and every row which you quite decide for to delete (you need to use Edit -> Fill -> Down - you recognize what I advise) then use the Autofilter on that column, view basically the 1s and then go with and delete those rows. pass on your filter out and choose All to verify all your information lower back. turn off your vehicle filter out. Voila!