The content of this site are my own personal opinions and do not represent my employer's view in anyway. In addition, my thoughts and opinions often change, and as a weblog is intended to provide a semi-permanent point in time snapshot you should not consider out of date posts to reflect my current thoughts and opinions.
This is a simple tip for MS Excel 2007. When using Outlook 2007/Word 2007 and working on a Table we get the "Design" menu which is very handy to make our tables look beautiful.
When working with MS Excel 2007 I couldn't find this feature (Design Menu for Table) till yesterday. It suddenly struck me that in Excel though everything appears to a "Table", but they are not and we need to explicitly create a "Table". That's it, feature found!
Steps to follow: Just select the cells you are interested in, choose the "Table" menu option from the "Insert" Ribbon bar. Viola. You get the Design Ribbon bar.
By default, when you insert a "Table" in Excel it comes with Data "Filter" enabled. You can disable it from "Filter" button in the "Data" Ribbon bar.
Remember Me