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)
If you have a favourite quote, send it to me and I may post it in my newsletter.
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.
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.
2) Now, right-click, choose Delete, Entire Row, OK.
|"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