Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto insert of blank lines
After importing data into excel, I have the need to insert blank lines after
each data line to make the data easier to work with. I have been doing it manually, but it takes a long time on big spreadsheets. Is there a way to have excel insert a blank line after each data line automatically? I am using excel 2003. Thanks for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto insert of blank lines
One way ..
Assume you have 10 data lines in rows 1 to 10 Insert a new col A, fill the series:1,2,3.. 10 in A1:A10. Copy A1:A10, paste into A11:A20 Then select the entire sheet, sort by col A ascending. This gives you the required results - blank lines insertion between each data line. Delete col A to clean up. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Robert" wrote: After importing data into excel, I have the need to insert blank lines after each data line to make the data easier to work with. I have been doing it manually, but it takes a long time on big spreadsheets. Is there a way to have excel insert a blank line after each data line automatically? I am using excel 2003. Thanks for any help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto insert of blank lines
Rather than inserting a blank row between rows of data maybe just double the row
heights of the existing rows for appearance. Blank rows will make it very difficult work with your data when you need to sort or filter or copy/paste. Gord Dibben MS Excel MVP On Wed, 28 Nov 2007 06:54:01 -0800, Robert wrote: After importing data into excel, I have the need to insert blank lines after each data line to make the data easier to work with. I have been doing it manually, but it takes a long time on big spreadsheets. Is there a way to have excel insert a blank line after each data line automatically? I am using excel 2003. Thanks for any help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto insert of blank lines
Thanks I will try this.
"Robert" wrote: After importing data into excel, I have the need to insert blank lines after each data line to make the data easier to work with. I have been doing it manually, but it takes a long time on big spreadsheets. Is there a way to have excel insert a blank line after each data line automatically? I am using excel 2003. Thanks for any help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto insert of blank lines
I thought of this, the problem though that I have is that all row are not the
same size, unless you know how to double the size when the rows might be different sizes. Thanks "Robert" wrote: After importing data into excel, I have the need to insert blank lines after each data line to make the data easier to work with. I have been doing it manually, but it takes a long time on big spreadsheets. Is there a way to have excel insert a blank line after each data line automatically? I am using excel 2003. Thanks for any help. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto insert of blank lines
Robert
Sub foo() Dim c As Range For Each c In Selection c.RowHeight = c.RowHeight * 2 'or 1.5 or whatever you choose Next c End Sub Believe me.....you will have fewer problems if you don't insert blank rows. Gord On Wed, 28 Nov 2007 12:10:02 -0800, Robert wrote: I thought of this, the problem though that I have is that all row are not the same size, unless you know how to double the size when the rows might be different sizes. Thanks "Robert" wrote: After importing data into excel, I have the need to insert blank lines after each data line to make the data easier to work with. I have been doing it manually, but it takes a long time on big spreadsheets. Is there a way to have excel insert a blank line after each data line automatically? I am using excel 2003. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add button to bottom of spreadsheet to delete blank lines auto | Excel Discussion (Misc queries) | |||
macro to insert blank line when lines sum to zero | Excel Discussion (Misc queries) | |||
Macro not recognizing blank lines as blank | Excel Discussion (Misc queries) | |||
Macro to insert blank lines | Excel Discussion (Misc queries) | |||
auto insert blank line | Excel Discussion (Misc queries) |