Excel Tutorial - Insert Alternate Blank Lines

I have a standard list in Excel and I want to insert multiple alternate
blank rows automatically so that these rows can be used for additiional data
at a later stage.

Can anyone offer advice as to how this can be done?

Thanks in advance.

I've searched previous threads and haven't found exactly what I'm looking
for, so here's my question: I need a macro that could insert completely
blank lines ( I mean completely blank aka white unformatted empty lines
with nothing inside) based on a range I select with my mouse

examples:

I highlight B4H9 on my spreadsheet and new empty unformatted rows are
created between rows 4 and 9, and, active cell becomes A4

I highlight E2H45 and new empty unformatted rows are created between
rows 2 and 45, and, active cell becomes A2

etc...

thx!!

I wonder if anyone already has a macro for the following operation I
perform quite often please? I insert blank lines in a long table
whenever a particular column changes. A typical example is in a list
containing a Year column, sorted by Year. It improves readability to
add a blank line between the 1972 and 1973 sections, 1973 and
1974...etc.

--
Terry, West Sussex, UK

I want to inset 2 or 3 blank lines before row(10) and row(16) and row(22) ...to row (300)

what is the code?

I frequently have to copy/paste data from several sites into a spreadsheet. The job is long and tedious and I know there is a way round it but I cannot get it.

When I paste into the spreadsheet, I have two problems.
Each data segment covers three lines and there may be between 50 - 100 segments. I only need data from the first line of each segment so I need to remove every second and third line. When pasting, I get a lot of images (bullet points I suppose). I have been selecting each one, grouping them and then deleting the group. Is there a way to select all images/controls on a sheet in one foul swoop? I do have a work around but this would be easier.
Thanks

Hello,

I've got a basic column chart with vertical grid lines but no horizontal grid lines. On my category axis I have week ending dates. All I want to be able to do is stagger the background color between each day (between each major grid line) so that they alternate between gray and white (e.g. 1/8/11 white, 1/15/11 gray, 1/22/11 gray, etc.). I'm sure there has to be a fairly simple way to do this but I haven't been able to find it. Any ideas?

Thanks!

I have an extremely large excel spreadsheet, filled with names and addresses,
which is 5 rows, to make the spreadsheet more readable, i would like to
insert a line every five rows. Is this possible, with out doing it manually.

I have a spreadsheet that contains different sku's numbers. The same sku is likely to be produced at different locations. So each individual sku has been grouped with itself and where it is produced with blank lines between different sku's. Each sku has an inventory balance in dollars at each location for every month. I need a macro to go through and sum each individual sku's monthly total inventoru value and then ideally get the average for the 12 months. I would do this manually but I would need to do so for other 150 sku's and it would be very tedious. If anyone has a macro they have used or modified that can sum groups of info between blank lines it would be most helpful. I am sorry I cannot screenshot it as it is company sensitive.

Thanks,
Adam

OS = XP Pro latest sp; MSOffice Pro 2003 latest sp

I am using SQL Reporting Services (Sp1) to export data to Excel. The SQL
query grabbing the data requires a case statement with carriage returns to
format Address data. For instance the output looks as follows:

SRT: ATTN: Sales
1603 Plasma Ave
Stonewashed, IL 60135

When I export the report to Excel, the cell containing the address info gets
formatted with a blank line (within the cell) between each address line. For
instance:

SRT: ATTN: Sales

1603 Plasma Ave

Stonewashed, IL 60135

Is there a way to update the address column to remove these blank lines? I
have attempted various formatting tricks in SQL Reporting Services and
nothing seems to work. So, I thought there might be a way to export the data
to Excel then update that column to remove the blank lines.

Any help would be welcome...

Hadyn