#1
|
|||
|
|||
worksheet row to print on two or more printout lines
I want to print two or more lines per worksheet row with a blank print line separating snaking rows. I have a 50 column job cost report that will not fit well on one print line regardless of formatting. I want a printout like I get with other accounting applications. Experienced user.
|
#2
|
|||
|
|||
.
You can use this macro to insert a blank row between existing rows of data on your worksheet: Code:
Option Explicit Sub Insert_Blank_Rows() 'Select last row in worksheet. Selection.End(xlDown).Select Do Until ActiveCell.Row = 1 'Insert blank row. ActiveCell.EntireRow.Insert shift:=xlUp 'Move up one row. ActiveCell.Offset(-1, 0).Select Loop End Sub |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help! Why do straight lines have a sawtooth edge when I insert an image and print from Powerpoint? | SnowPatrol161 | PowerPoint | 1 | 02-06-2017 09:01 AM |
Lines separate paragraphs in Print Layout view | FKerr | Word | 5 | 08-13-2015 11:45 AM |
Word 2010 Printing Lines NOT Showing on Print Preview | kziemke | Word | 4 | 06-02-2015 07:16 AM |
printer can't print out the lines | pclum | Word | 4 | 07-02-2011 02:36 AM |
Unable to print blank lines on a legal form | dpenbag | Word | 0 | 03-20-2006 09:13 PM |