This is a great way to quickly change the number format of a cell, or to apply other formatting options.ĥ. Ctrl+Shift+U (Windows) or Option+Fn+U (Mac): This shortcut will open the Format Cells dialog box, which can be used to format cells. This is the first step in creating a formula, and is a great way to quickly create a simple formula without having to open the Insert Function dialog box.Ĥ. Ctrl+= (Windows) or Option+Fn+= (Mac): This shortcut will insert the equal sign (=) into a cell. This is a great way to see a list of all the available functions in Excel, as well as get a description of what each function does.ģ. Ctrl+Shift+F3 (Windows) or Option+Fn+F3 (Mac): This shortcut will open the Insert Function dialog box, which can be used to insert a function into a cell. If formulas are currently hidden, they will be displayed.Ģ. If formulas are currently being displayed, they will be hidden. Ctrl+` (Windows) or Option+Fn+F9 (Mac): This shortcut will toggle the display of formulas on and off. That's why we've put together this list of 15 keyboard shortcuts to help you quickly and easily show formulas in Excel.ġ.

But if you're new to Excel, or if you're not familiar with the many different ways formulas can be used, they can be a bit daunting. They're what make it possible to perform complex calculations with just a few clicks. Formulas are the key to getting things done in Excel.

Insert equation in word mac shortcut