Skip to main content

Excel 2007 Tip: How to sort your highlighted rows

I have thank this tip to my operations manager who told me a few hours ago that it was possible to sort highlighted rows in Excel 2007.

I went like “WOW”!

Sorting highlighted was one of the biggest challenges for me when I was at Cisco Systems.

I was repeatedly asked then on how to sort highlighted bars and found it was Microsoftly impossible to do so.

As excel sheets were one of the Office tools that ruled Cisco Systems with the endless reporting, I felt that it was necessary to share this tip with you.

image Above is your standard excel table and rows. You notice that I highlighted row 4. Let’s say we want to move this highlighted bar to the top.

Right click on the highlighted row and go to the “sort” option. Select “Put Selected Color on Top”.

image image Viola! Your highlighted row is now at the top.

Assume now that I have a few rows highlighted and I would have to sort by the highlighted blue bar.


Highlight the selected table and Right click on the highlighted row and go to the “Sort” option. And select “custom sort”.

The option box will appear. Say we sort by No, next choose Sort on Cell Color and select the order by colors bar. You end it if you want the selected color On Top or On Bottom.

image Again, it sorts by No but based on the order of the color bars.


Vestige said…
Good tip there :)
Aaron Koh said…
Thanks Vestige.

I wondered if it was a right thing to put an excel tip on this blog about social media.

But guess its better to share on an active blog rather than to start a new one.

This was one of those tips when I heard about it that made me go "WOW! You can do this now!" as faced a lot of request to do so in my previous jobs.
Anonymous said…
So hopefully - just what I needed. Easy, clear instructions! THANK YOU!

Popular posts from this blog

Why is Ramly Burger banned in Singapore?

Yahoo Singapore ran an article of the Ramly Burger by highlighting that it is ban in Singapore.

Yet, the writer from Makansutra failed to address the most important issue of why the Ramly meat patty is banned in Singapore.

A search online easily did highlight that the famous Malaysian meat patty is banned by the AVA but didn't go into details.

Wrote Arlina Arshad for The Straits Times in January 2004,

"But the importing of beef and beef products from Malaysia is not permitted, said theAgri-Food and Veterinary Authority (AVA).

Selling and supplying them without a permit is also an offence, and offenders can befined as much as $50,000 or jailed two years, or both, said the AVA."

In May of the same year, another article highlighted that a man was even charged in court for "smuggling" the Ramly burger in 2004.

"The AVA said that meat products processed in Malaysian food factories which it had notapproved were banned here.Suzali was yesterday jailed for four month…

Those Who Gamble Online Have Poorest Control - NCG Survey In 2012

Singapore will soon exempt local operators, Singapore Pools and Turf Club, from online gambling ban and the sites will be ready in November 2016.

Ministry of Home Affairs explained that a complete ban on remote gambling drives demand and activities underground, and may create larger incentives for criminal syndicates to target Singapore."

Yet in a 2012 survey by the National Council on Problem Gambling (NCG) found that those who gamble online have the poorest control.

For those who indulged in online gambling, 30.4% said they gambled for a longer period than they planned to, 33.3% gambled with more money than they planned and 29.2% gambled more frequently they planned to. 
Will launching the online gambling sites be like opening a Pandora Box that will create more issues in the future?

A Very Small Chicken Or An Oversized Popcorn Chicken?

Kentucky Fried Chicken (KFC) Singapore Facebook Page recently received a complaint of the size of the chicken being served at KFC.

Barnabas Ng took a photo of his chicken from KFC which showed it to be almost the size of the KFC small container. It also looked like a an oversize popcorn chicken.

Wrote Barnabas,

"Hi KFC, is this your new standard size for a chicken? I order 3 piece meal and 2 pieces including this so called original recipe chicken is smaller than the size of the cap of ur small mash potato.

Have you guys try to cut cost so much that you are offering half a size chicken pieces for a full price meal? It is just getting from bad to worse"

KFC Singapore did reply to Barnabas for him to PM his mobile number but Barnabas has yet to receive any calls from KFC Singapore, as of this posting.

Maybe chickens are also shrinking with the current climate change?