RE: Automatically Inserting Rows

[allyne]

Hello Everyone,

I'm new to excel and I am using Excel 2007. I have a spreadsheet that looks something like this. It has one column with data.

Names (Column Name)
Name1
Name2
Name3
Name4

What I want it to do is look like this. I want a blank row inbetween each row.

Names (Column Name)
Name1

Name2

Name3

Name4

Can Excel do this I thought it would be a format issue but I can't out how to do this anywhere in excel. This spreadsheet has 4 thousand rows.....

Any help would be appreciated!

Thanks!

 

[Gavona]

Firstly do you want additional rows or to double the hieght of the current rows? Generally not a good idea - what is your objective?

To insert blank rows I would (Excel 2003, sorry) Data, Subtotals to add subtotals at change in name, thus inserting blank rows.
Use the Group and Outline symbols to hide the detail rows - only showing the subtotals.
Select all and clear the contents (delete key)
Remove grouping and outlining.

Gavin

 

[allyne]

Thanks for your quick response. I wanted to insert blank row. I think I may have a computer that still has 2003. I'll give it a try!
Thanks for your help!

 

[Gavona]

I am sure the same functionality will be there in 2007. Indeed I have a workbook that maps the commands. ........Here you go:

Subtotals > Data | Outline | Subtotal

Group and Outline | Hide Detail > Data | Outline | Hide Detail
Group and Outline | Show Detail > Data | Outline | Show Detail

Group and Outline | Clear Outline > Data | Outline | Ungroup | Clear Outline

Gavin

 

[SkipVought]

I STRONGLY agree with Gavin that it is HARDLY EVER a good idea to destroy a perfectly good table by inserting empty rows or columns. In doing so, you defeat the ablilty of Excel to perform many features that are related to data analysis and reporting. You may as well use MS Word tables. My mess with Excel?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[allyne]

Hi Everyone,

Thanks for your responses! They've been very helpful. I should have probably let you know that I'm not doing this for excel purposes. I'm copying and pasting data from another piece of software and wanted to insert the blank rows and copy and paste it back into the software as it doesn't have the capabilities to do so.....

Thanks again for all your help!