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!