Showing posts with label insert rows. Show all posts
Showing posts with label insert rows. Show all posts

Sunday, December 27, 2009

Inserting Multiple Empty Rows in Excel

The other day, I was preparing a dashboard and I came across this problem:
I had a few rows of data and I had to insert multiple empty rows (5) in between each row. Initially I wrote a simple VBA macro to do it, but later a colleague showed me a much simple way to doing the same thing using Excel’s “Sort” function. Here’s how:

Feeds