Controlling (Ctrl) Your Formulas!

I just recently learned five new shortcuts using the Ctrl key.  Three of them are beneficial when working with formulas.  The other two I’ll talk about tomorrow.  They are:

– Ctrl + ~ (tilde)
– Ctrl + [ (left bracket)
– Ctrl + ] (right bracket)

Ctrl + ~:
This shortcut switches your spreadsheet from showing results to showing formulas.  Here’s a simple spreadsheet that contains formulas:

When I hold down Ctrl and hit ~ I get:

Holding down Ctrl and hitting ~ again returns it to normal.

Ctrl + [ (left bracket):
Holding down Ctrl and hitting [ while in a cell with a formula will highlight the cells related to that formula.  Using the above referenced spreadsheet, holding down Ctrl and clicking on [ while in cell F5, which has the formula =SUM(F2:F4):

Cells F2 through F4 are highlighted:

Ctrl + ] (right bracket):
Holding down Ctrl and hitting the ] key will show the cells that contain formulas using the cell you are on.  For example, if I use that shortcut while in cell B2:

You will see that cells F2 through H2 along with cell B5 are all highlighted, since they use B2 in their formulas.  If you try it will a cell that is not used in another formula, a pop up will appear indicating that no cells were found.

More to come tomorrow!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

0 Responses to Controlling (Ctrl) Your Formulas!

  1. Steve Daukas April 30, 2013 at 10:46 pm #

    It’s always great to learn new and quick tools to make it easier and faster ti work with Excel. Thanks Mike

  2. Michael Rempel April 30, 2013 at 10:59 pm #

    Steve,

    Glad you are enjoying the posts!

    MAR

Leave a Reply