Friday, May 12, 2017

A Cheater's Way To Add Blank Lines Between Spreadsheet Lines

So there you have it, a sorted list of titles or names or what not, all neat and tidy in your Excel spreadsheet. Or what ever other app you use. But when you post it, you get a look you don't like. It feels crowded and you would feel better if you had a space between each item in your list because if you wanted to copy and paste it into a blog post or something like that, it would just look a little better. Right?

Fine. I know there are fancy ways to add blank lines between every line in Excel but I'm tired of trying to remember it or continually look it up.  But I have a method that is very very easy to remember.  Here it goes.

And of course, I did this in Excel, but should work in any spreadsheet program.

-  Input your list of titles in a column.

-  Sort that list alphabetically, or however you want to.

-  In the column just left of your entries, add numbers next to your titles. 1, 3, 5, 7... one per title so each title has a number to the left of it.

-  Then highlight those four numbers, grab the highlight anchor and drag it down the spreadsheet so that the numbers are continued on down the page next to your titles. So now you have a list of odd numbers next to your titles, each title with one number next to it.

-  Now take note of the last number you have. In my case, I had 153.

-  Below your titles on the spreadsheet, but in the same column that you have your odd numbers, type a new set of numbers going down your page, but this time, make them even numbered.  2, 4, 6, 8, 10... 

-  Highlight these new numbers, and drag down your page, until they go past 153. So now you have a column of even numbers.  And it's important that you did this below the column of odd numbers, continuing down and extending the length of that column.

-  Now go to the top, highlight the column of numbers and your titles, then sort the numbers, 1, 2, 3, 4... and boom, you now have a list of titles, with a line space between each title. Now you can copy and paste as needed.

-B

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Follow or subscribe to Consumer Bits on

Thursday, March 30, 2017

RECALLS From LOWES, TARGET, AMAZON, HOME DEPOT, HP And more

RECALLS From LOWES, TARGET, AMAZON, HOME DEPOT, HP And more

These product recalls are for things distributed or sold through LOWES, TARGET, AMAZON, HOME DEPOT, HP And more

- - - - -

Bar Chairs Sold at Lowe’s Stores Recalled Due to Fall Hazard; Made by 3i Corporation

The legs can become detached from the center post at the weld, posing a fall hazard.

Contact: 3i Corporation toll-free at 866-267-7772 between 9 a.m. and 5 p.m. ET Monday through Friday or online at www.lakeview-safford.com.

- - -

Barnes & Noble Recalls Power Adapters Sold with NOOK Tablet 7 Due to Shock Hazard

The power adapter casing can break when plugged into an electrical outlet, exposing its metal prongs, posing an electric shock hazard.

Contact: Barnes & Noble toll-free at 877-886-5025 from 8 a.m. to 11 p.m. ET, Monday through Friday, or 9 a.m. to 11 p.m. ET on Saturday and Sunday, or online at www.barnesandnoble.com and click on “Product Recalls” listed at the bottom of the page.

- - -

Bolton Furniture Recalls Dressers Due to Serious Tip-Over and Entrapment Hazards.

They're sold at Full Line Furniture and children’s specialty stores nationwide and online at Amazon.com, Overstock.com, Target.com, ToysRUs.com, Wayfair.com, Zulilly.com and other online retailers

The recalled dressers are unstable if they are not anchored to the wall, posing a serious tip-over and entrapment hazard that can result in death or injuries to children. The dressers do not comply with the performance requirements of the U.S. voluntary industry standard (ASTM F2057-14)

Contact: Bolton Furniture at 800-545-8982 from 8 a.m. to 4:30 p.m. ET Monday through Friday or online at www.boltonfurniture.biz and click on the “News” section and then Safety Recall.


Wednesday, January 4, 2017

About That Cuisinart Food Processor Recall

Cuisinart Food Processor Recall


Hey, in case you had not heard about it, Cuisinart has put out a massive recall on their Food Processors.

Below is some of the info you may need to know...

- - -

Cuisinart Food Processors Recalled by Conair Due to Laceration Hazard; The food processor’s riveted blade can crack over time and small, metal pieces of the blade can break off into the processed food. This poses a laceration hazard to consumers.

Contact: Cuisinart toll-free at 877-339-2534 from 7 a.m. to 11 p.m. ET Monday through Friday and from 9 a.m. to 5 p.m. ET Saturday and Sunday or online at  www.cuisinart.com and click on Product Recalls at the bottom of the page for more information on the voluntary recall.

This recall involves the riveted blades in Cuisinart food processors with model numbers that begin with the following:  CFP-9, CFP-11, DFP-7, DFP-11, DFP-14,  DLC-5, DLC-7, DLC-8, DLC-10, DLC-XP, DLC-2007, DLC-2009, DLC-2011, DLC-2014, DLC-3011, DLC-3014, EV-7, EV-10, EV-11, EV-14, KFP-7 and MP-14. The model number is located on the bottom of the food processor. The blades have four rivets and are silver-colored stainless steel and have a beige plastic center hub. Only food processors with four rivets in the blades are included in this recall. Cuisinart is printed on the front and on the bottom of the food processors.

- - -

Incidents/Injuries: Conair has received 69 reports of consumers finding broken pieces of the blade in processed food, including 30 reports of mouth lacerations or tooth injuries.


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Follow or subscribe to Consumer Bits on