FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
November 26, 2015


Greetings from The Excel Addict
Hi fellow Excel Addict,

Wherever you are in the world, I hope you're having a fantastic week.

I want to wish my American readers a very happy Thanksgiving Day (Thursday). Even though, in Canada we celebrated Thanksgiving back in October, I am very thankful for and appreciate all 'Excel addicts' around the world who read my newsletter every week and share it with others.

I hope today's tip will make life a little easier for you.


Take care and keep on Excelling,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com

Francis Hayes (TheExcelAddict.com)


The Excel Addict Quote of the Week
“I slept and dreamt that life was joy.
I awoke and saw that life was service.
I acted and behold, service was joy.”
-- Rabindranath Tagore --

If you have a favourite quote, send it to me and I may post it in my newsletter.


Today's Microsoft Excel Tip

How to Quickly Insert Blank Rows Between All Rows

If you have a list of data and you need to insert a blank row between each row in the list (i.e. double-spacing), here is a cool little trick that takes just a few seconds.

1) Insert a new 'helper' column or use a blank column immediately to the right of your data;

2) In this column, enter 1 in the cell adjacent to your first row of data and in the next cell down type 2;

3) Select the cells containing 1 and 2 and double-click the Fill Handle [the small black square in the lower-right corner of a selected cell or range]. A series of numbers (1,2,3,etc...) is added from the top to the bottom of your list;

4) With that series of numbers still selected, press CTRL+C (i.e. Copy), select the first blank cell immediately below the current selection and press CTRL+V (i.e. Paste);

5) Now from the Data tab click the Sort command. In the Sort by' field, select the helper column that contains the series of numbers and click OK. The entire table will be sorted with a blank row between each data row;

6) You can now delete or clear the 'helper' column.

Insert A Blank Row Between Each Row Of Data Small in Microsoft Excel 2003, 2007, 2010, 2013, 365

If you need to insert just a few blank rows, you can simply select one cell in each row (e.g. B5,B6,B7,B8,B9), right-click and choose Insert, Entire Row, OK.

Select and Delete Blank Rows

And if you decide that you want to remove the blank rows...I've got that covered too.

1) Select all cells in a single column containing the blank rows, press the F5 key on your keyboard, click the Special... button, select the Blanks option, and click OK. This will select all blank cells.

Select And Delete Blank Cells in Microsoft Excel 2003, 2007, 2010, 2013, 365
2) Now, right-click, choose Delete, Entire Row, OK.


FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

Thanks for supporting this newsletter and website



Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com


 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
"Spreadsheets Tips From An Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630