Read the Beforeitsnews.com story here. Advertise at Before It's News here.

By Stock Kevin (Reporter)
Contributor profile | More stories

Story Views
Now:
Last hour:
Last 24 hours:
Total:

Excel Tip #10 - Change a Single Spaced Sheet into a Double Spaced Spreadsheet

Tuesday, November 5, 2013 0:37

% of readers think this story is Fact. Add your two cents.

Three Step Process to Instantly Adding a Space Between Rows in a Table

Within Excel, there is more than one way of adding spaces between row in a data set. We can manually add blank rows or we can use a shortcut such as holding Ctrl Shift and +. These two methods are absolutely acceptable if you only have a couple of rows. But what if you had a hundred or a thousand rows? It would take you a long time to change your single spaced sheet into double spaced. Luck for you, there is a more efficient way to do this.

Suppose your end goal is illustrated below (ignore column F for now). You want each row of data to be separated by a blank space. This could be because you want your data to look cleaner or just easier to read.

You started with the below data set. One way of spacing this out is by adding numbers to the right or left side of the data set. In the below spreadsheet picture, we’ve labeled each row of data from one to eight. Then just below it repeat the same numbers.

After you’ve finished labeling the rows as such, find the filter button which is under ‘Sort & Filter’. You can then either sort from smallest to largest or largest to smallest. Depending on how you sort, your list could be flipped or remain the same. Pick smallest to largest and if that is how you labeled it, then it will look as if you just add extra rows to your original data set.

After that you should get your double spaced spreadsheet. You can now delete the column you added and your sheet will still be spaced. And that is how you change a single spaced sheet into a double spaced spreadsheet!

Source: http://www.stockkevin.com/2013/11/excel-tip-10-change-single-spaced-sheet.html

Before It’s News® is a community of individuals who report on what’s going on around them, from all around the world.

Anyone can join.
Anyone can contribute.
Anyone can become informed about their world.

"United We Stand" Click Here To Create Your Personal Citizen Journalist Account Today, Be Sure To Invite Your Friends.

Please Help Support BeforeitsNews by trying our Natural Health Products below!

Order by Phone at 888-809-8385 or online at https://mitocopper.com M - F 9am to 5pm EST

Order by Phone at 866-388-7003 or online at https://www.herbanomic.com M - F 9am to 5pm EST

Order by Phone at 866-388-7003 or online at https://www.herbanomics.com M - F 9am to 5pm EST

Humic & Fulvic Trace Minerals Complex - Nature's most important supplement! Vivid Dreams again!

HNEX HydroNano EXtracellular Water - Improve immune system health and reduce inflammation.

Ultimate Clinical Potency Curcumin - Natural pain relief, reduce inflammation and so much more.

MitoCopper - Bioavailable Copper destroys pathogens and gives you more energy. (See Blood Video)

Oxy Powder - Natural Colon Cleanser! Cleans out toxic buildup with oxygen!

Nascent Iodine - Promotes detoxification, mental focus and thyroid health.

Smart Meter Cover - Reduces Smart Meter radiation by 96%! (See Video).

Comments

Online:
Visits:	1,601,119,728
Stories:	8,143,328