How to Delete Empty Columns in Excel with all Empty / Blank Cell Values

On the net you will find lots of info on how to delete empty columns in excel, using ‘go to special’. These are useless if you have some columns which have ‘some blanks’ and are looking for columns which have ‘only blanks’, because the method will delete the entire column even if it contains one blank cell.

I prefer instead to use the COUNTBLANK formula. Simply go to the last row/column of the data, and use countblank to find how many cells are empty/blank. then combine it with an IF statement, so that if the number of blanks is greater than the total number of columns/rows, then mark ‘delete’, and if not leave blank.

After this you simply sort your data by the column/row where you did the formula, and delete the relevant columns/rows. (Remember, when trying to delete empty columns, you will need to sort the data by the row which contains the formula. You do this by opening the ‘sort’ box and then pressing ‘options’ button)

Formula:

IF(COUNTBLANK(R[-27110]C:R[-1]C)>27109,”delete”,””)

in the above example, 27109 was the number of rows of data in my data – yours will be a different number.

delete empty columns in excel

 

 

List of Car Names for making sentences, stories or word games

Buy a car concept on brown paper bag which businessman has on head on cityscape backgroundList of Car Names which you can use as words for making funny sentences, stories, trivia/quiz challenges and word games.

The following English words are also the names of cars:

Applause, Beetle, Bluebird, Boxer, Caddy, Carry, Cavalier, Cherry, City, Cobra, Commander, Compass, Crown, Cube, Daily, Defender, Discovery, Dispatch, Expert, Fox, Ghost, Golf, Idea, Insight, Iq, Juke, Legend, Liberty, Logo, Magnum, Master, Metro, Midget, Mini, Montreal, Note, Panda, Partner, Patriot, Phantom, Pick Up, Picnic, Polo, Pony, Rapid, Rascal, Relay, Scenic, Shuttle, Spider, Sprinter, Stream, Superb, Swift, Trafic, Transporter, Tribute, Up, Wind, Yeti

And below is the breakdown of what car’s these are:

Model Word Associated Make
COBRA AC
LEGEND ACURA
MONTREAL ALFA ROMEO
SPIDER ALFA ROMEO
DISPATCH CITROEN
RELAY CITROEN
APPLAUSE DAIHATSU
IDEA FIAT
PANDA FIAT
CITY HONDA
INSIGHT HONDA
LEGEND HONDA
LOGO HONDA
SHUTTLE HONDA
STREAM HONDA
PONY HYUNDAI
DAILY IVECO
COMMANDER JEEP
COMPASS JEEP
LIBERTY JEEP
PATRIOT JEEP
DEFENDER LAND ROVER
DISCOVERY LAND ROVER
TRIBUTE MAZDA
SPRINTER MERCEDES-BENZ
METRO MG
MIDGET MG
MINI MINI
BLUEBIRD NISSAN
CHERRY NISSAN
CUBE NISSAN
JUKE NISSAN
NOTE NISSAN
PICK UP NISSAN
BOXER PEUGEOT
EXPERT PEUGEOT
PARTNER PEUGEOT
MASTER RENAULT
SCENIC RENAULT
TRAFIC RENAULT
WIND RENAULT
GHOST ROLLS-ROYCE
PHANTOM ROLLS-ROYCE
RAPID SKODA
SUPERB SKODA
YETI SKODA
CARRY SUZUKI
SWIFT SUZUKI
CROWN TOYOTA
IQ TOYOTA
PICNIC TOYOTA
CAVALIER VAUXHALL
MAGNUM VAUXHALL
RASCAL VAUXHALL
BEETLE VOLKSWAGEN
CADDY VOLKSWAGEN
FOX VOLKSWAGEN
GOLF VOLKSWAGEN
POLO VOLKSWAGEN
TRANSPORTER VOLKSWAGEN
UP VOLKSWAGEN

Facebook is hard to use

I’m not from an IT background, but over the years I’ve often needed to learn new softwares and websites for business. e.g. ebay, shopping carts, wordpress, linkedin etc and I like to think I’m quite fast as picking up these things. And then there’s Facebook. I used Facebook a few years back as I had a personal account and at that time I remember it being simple.

I’ve now had to go back to Facebook to promote my business and I am literally pulling my hair out – I’m finding Facebook’s site functionality and navigation to be very frustrating. Doing simple things like adding photos, which I would normally figure out in seconds, take me ages to figure out. Editting my business page and adding additional functionality like apps and feeds and proving very difficult.

My message to Mark Zuckerberg – make your site easier because right now it’s feels as ergonomic as gloves on feet.

Anyway, that’s my moan for the day. If you stumble across the Doctor Car Parts Facebook Page, bear with me while I struggle with it.