How to insert an empty cell down the column?

**gabrielemucho** · 10-25-2013, 06:19 AM

Hi,

Can anyone suggest how to automate inserting empty cells down the column in a regular manner - e.g. after every cell?

The original data and the expected outcome are illustrated in the attached jpg fileEXCEL.JPG

Thanks,
G

**sktneer** · 10-25-2013, 06:42 AM

You can do it formula but will be a lengthy one. Instead use a macro to get this done easily.

Please Login or Register  to view this content.

Hope it helps.

**gabrielemucho** · 10-25-2013, 09:00 AM

Hi,

many many thanks, it does work! How to modify the macro if this time I'd like to insert an empty cell after every second cell, instead of after every single cell?

Thanx,
G

**sktneer** · 10-25-2013, 10:53 AM

Try this.....

Please Login or Register  to view this content.

How to insert an empty cell down the column?

LinkBack

Thread Tools

Rate This Thread

Display

How to insert an empty cell down the column?

Re: How to insert an empty cell down the column?

Re: How to insert an empty cell down the column?

Re: How to insert an empty cell down the column?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] userform insert data on next empty row in specific column regardless of formulas

[SOLVED] Copy Column as Selection and Insert to the next Empty Column MACRO

Macro to insert a letter into first empty cell in a column on all sheets

Insert data from one column into the empty cells of an adjacent column

[SOLVED] how insert same text in empty cells in column (10000 rows)

Bookmarks

Bookmarks

Posting Permissions