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.

image

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

image 
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.

Comments

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…

Did She Run Or Did She "Just Fake It" For Adidas?

Andrea Chong, a Adidas appointed influencer, posted a photo of herself in the middle of the Standard Chartered Singapore Marathon 2015 and captioned how she was "all smiles" during the run.

Unfortunately for Andrea or the PR agency, one of her readers checked her bib number #75148  at the Marathon's website only to find it to belonging to somebody else.

That somebody else is Kuvin Kuar, a intern at Edelman PR and the bib number had a status "DNF" or did not finished.

This raised the first red flag as one of the rules stated that "A Participants is strictly not allowed to transfer his or her race entry to another party".

This cascaded into perceptions that Andrea herself did not even start or complete the race and was only "planted" by Adidas or the PR agency, Edelman PR, to look pretty in the marathon.

Marketing Magazine noted that Adidas declined to comment about the incident which lead to further speculation that Andrea was possibly just …

Kudos To Huawei 2 Year Warranty For P9 Series

When it comes to smartphones, I think I am jinxed.

For my history of owning smartphones, every time it comes close to the end of the two year contract with my mobile service provider. This time round, it happened to my Huawei P9.

All of a sudden, the LCD screen sort of decolourised. I thought it was a temporary issue but the decolourisation lasted for a few hours. Then the nightmare began.

The touchscreen couldn't be touched. This made it the smartphone a brick.

I thought the Huawei P9 only had one year of warrant. With my contract ending in mid-year, I thought I would have to wait it out till the contract ended and allowed me to buy a new phone under a contract.

Luckily, a friend reminded me that the phone came with a 2 year warranty.

So I decided to go to the Huawei service center, right smack in the center of the city, to see if my phone is under warranty and if Huawei would honour their 2 year warranty.

Thankfully, Huawei isn't as popular as the Samsungs or Apples, and the …