Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need to print cells under the orginal line instead of page break
I have rows of cells which on a landscape print preview would carry over 2
pages. I want to print so that when it reaches the end of the page it continues underneath with the same row. In other words if I have 20 columns with rows underneath containing responses, how can i print so on line 1 it shows A1 to J1 and then on line 2 it shows K1 to T1. Line 3 would then be A2 to J2 and line 3 K2 to T2 etc. |
#2
|
|||
|
|||
Invo
Assuming 20 columns and you want 1-10 on row 1 and 11-20 on row 2 etc. Make a copy of the sheet then run this macro on the copied sheet. Sub WrapUnder() Dim i As Long For i = Range("A1").End(xlDown).Row To Range("A1").Row Step -1 Cells(i + 1, 1).EntireRow.Insert Cells(i, 1).Range("K1:T1").Cut Cells(i + 1, 1) Next i End Sub If not familiar with VBA and macros, see David McRitchie's site for more on "getting started". http://www.mvps.org/dmcritchie/excel/getstarted.htm In the meantime.......... First...create a backup copy of your original workbsheet. To create a General Module, hit ALT + F11 to open the Visual Basic Editor. Hit CRTL + R to open Project Explorer. Find your workbook/project and select it. Right-click and InsertModule. Paste the code in there. Save the workbook and hit ALT + Q to return to your copied worksheet. Run the macro by going to ToolMacroMacros. You can also assign this macro to a button or a shortcut key combo. Gord Dibben Excel MVP On Sun, 28 Aug 2005 18:28:03 -0700, "InvoCare" wrote: I have rows of cells which on a landscape print preview would carry over 2 pages. I want to print so that when it reaches the end of the page it continues underneath with the same row. In other words if I have 20 columns with rows underneath containing responses, how can i print so on line 1 it shows A1 to J1 and then on line 2 it shows K1 to T1. Line 3 would then be A2 to J2 and line 3 K2 to T2 etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I there a way to not print a cell(s)? | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |