Shortcuts Used in Formulas

This post will provide you the keyboard shortcuts used while we are working on Formulas in Excel.

Keyboard Shortcuts

What it Does?

F4

Switch between Absolute /Relative References

F9

Recalculate the work book

CTRL + '

Copy the formula from above cell

SHIFT + F3

Formula Search Option

SHIFT + F9

Calculate active worksheet

CTRL + ALT + SHIFT + F9

Calculates all workbooks after rechecking the dependent formulas

CTRL + A

After opening the sqare brackets use CTRL + A to display its arguments

TAB

when you type a letter, corresponding functions will display, select the appropriate and hit tab to activate that function

)

We can skip the last closed paranthesis because Excel automatically takes it.

= or +

We can start the formula either with the ''is equal to" or "plus" symbols, always.

F5 + ALT + S +F

Use this shortcut to select all the formulas in the worksheet

CTRL + SHIFT + ENTER

To create an array formula

CTRL + ~

This shortcut shows all the formulas in the worksheet.

...

DID YOU USE SHORTCUTS?

If you are using different shortcuts apart from this, please teach us by posting in the comments below. If you like this post, please do share it on your social networking sites by clicking on the icons placed around the blog.

If you want to support me for maintaining this blog, REGISTER here. All registries will receive updated posts through your email id's.

We love to keep your information securely because information security is our first priority.