Nov 28

A Macro way to Excel

tips Add comments

Ever tried to find the uppercase button in Microsoft Excel or tried to strike through text in the cell?

Yes! You will end up with a big surprise that there are no such one-click buttons available in MS Excel. So what will you do to change all uppercase letters from a row to Sentence case?

Difficult? Not really! Here is a 2 step solution to add these MISSED features:

  1. Download : Personal.xlsb
  2. Copy the downloaded file to following location : C:\Documents and Settings\<your-username>\Application Data\Microsoft\Excel\XLSTART

So How does this benefits you?

This Excel Binary File contains macros for following operations:

  1. Toggle Uppercase (Ctrl+u)
  2. Toggle Lowercase (Ctrl+l)
  3. Toggle Sentence Case (Ctrl+Shift+s)
  4. Toggle Strike Through (Ctrl+k)
  5. Toggle Superscript
  6. Toggle Subscript

Impressive? Aha! You can add all you want with macros.

So learn to look at the Macro level :)

Note:

1. Please make sure macros are enabled.

2. All those who want to look what exactly goes behind the screen, goto MS Excel VB Editor and have a look at the code.

Leave a Reply