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.

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

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.

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

Comments

minicharms said…

Good tip there :)

March 17, 2009 at 12:23 PM

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.

March 17, 2009 at 12:39 PM

Anonymous said…

So hopefully - just what I needed. Easy, clear instructions! THANK YOU!

September 8, 2010 at 3:28 AM

Singapore radio personality in "hot soup" for reporting train delays based on Tweets?

Update - Hossan Leong has commented on this post to say " I'm not in trouble pls don't blow this out of proportion. Let it rest. It's getting silly. Thank you for your love and concern and I apologize for any misunderstanding." ~ Hossan Leong. Hossan Leong, a Singapore radio personality for The Gold Breakfast Show on Gold 90.5, was censured today for reporting on train delays on the Circle Line because he based the information on Tweets, rather than waiting for the official reports from the Circle Line operator, SMRT. It is, however, unknown if the "warning" came from Mediacorp producers or SMRT. Tweeted Hossan Leong , OK...I reported it on air and now I'm getting into trouble for it?? The CC line is DOWN rite? I did nothing wrong rite? The SMRT Circle Line was reported to be down this morning during peak hours and started as early as 7am. However, local news only received official statement was received by the mainstream media at about 9...

DBS Bank – One Tweet too little too late.

(Updated post - DBS apologise with the 3Rs – Will social media bite? ) It was the bluest Monday for DBS/POS Bank in its entire banking history when more than 1000 of their ATM and online banking services were taken offline due to a software upgrade an outage (PR announced that it was down due to software upgrade, but the outsourcer, IBM, later claimed it was an outage). So on that Monday, DBS decided to sign up onto Twitter and post a 140 characters one-liner onto Twitter to post a one liner to inform the Twitterverse of the down time. Everybody knows that if you just create a new account on Twitter, you would start off with 0 friends. How would you be able to inform the Twitterverse if you start with 0 friends? DBS Bank did something smart to insert the #dbs and #posb and that probably drew some attention to this account. However, the effectiveness of the tweet was lacking as it drew only 28 retweets. As of this posting, DBS Bank attracted 274 followers. A letter to T...

New field in SocialPR: Social Media Crisis Communications

I have been busy with family for the Lunar New Year week but it seem the Singapore blog-o-sphere was active, and is still is, about recently formed Association of Bloggers (Singapore), ABS for short. To cut a long story short, the announcement of ABS via mainstream media didn’t go down well with Singapore bloggers and in the end resulted in some speculation to why ABS was set-up in the first place. A post by the ABS president defending herself against a harsh criticism from a blogger added to the bad start and created even more speculation that ABS was set-up with an ulterior motive. A week later, some founding members of the pro-team started posting up notice of resignation on their blogs and this just added fuel to fire. Again, a story of ABS appeared in mainstream media and this lead to even more disgruntled bloggers asking why the president isn’t responding via her blog or the association’s blog. I also responded to a post about the ABS incident. You can catch a summary of...

Sales, Social and Tech

Search This Blog