Trace Circular Reference

In case if you are lost with the values and there is a circular reference, you can check the same using this in the formula tab

 

 

Menu Bar Control

You can enable / disable items in the Menu Bar back in VBA. The following is the Control Number to enable / Disable

 

CommandBar            Control                         ID

   --------------------------------------------------------------------

   Worksheet Menu Bar    &File                        30002

   Worksheet Menu Bar    &Edit                        30003

   Worksheet Menu Bar    &View                        30004

   Worksheet Menu Bar    &Insert                      30005

   Worksheet Menu Bar    F&ormat                      30006

   Worksheet Menu Bar    &Tools                       30007

   Worksheet Menu Bar    &Data                        30011

   Worksheet Menu Bar    &Window                      30009

   Worksheet Menu Bar    &Help                        30010

 

   Chart Menu Bar        &File                        30002

   Chart Menu Bar        &Edit                        30003

   Chart Menu Bar        &View                        30004

   Chart Menu Bar        &Insert                      30005

   Chart Menu Bar        F&ormat                      30006

   Chart Menu Bar        &Tools                       30007

   Chart Menu Bar        &Chart                       30022

   Chart Menu Bar        &Window                      30009

   Chart Menu Bar        &Help                        30010

 

 

Check Formulas

If you want to check which are the cells with formulas and which are not, you can use this simple quick highlighter to show you, you can find this in the Home TAB, right corner bottom

 

Find the nth Occurrence of a Character in a cell

If you want to find

 

A1 = This World is Very Big

 

To find the place of 3^rd I Use the following formula :  FIND("i",A1,FIND("i",A1)+3)

 

Here 3 represent nth occurrence