That browsing window will look like this: Nonetheless, the suite of icons above is a handy catalog of formulas you can browse and refer back to as you hone your spreadsheet skills.Įxcel formulas are also called 'functions.' To insert one into your spreadsheet, highlight a cell in which you want to run a formula, then click the far-left icon, 'Insert Function,' to browse popular formulas and what they do. The more you use various formulas in Excel, the easier it'll be to remember them and perform them manually. In more recent versions of Excel, this horizontal menu - shown below - allows you to find and insert Excel formulas into specific cells of your spreadsheet. Some laptops have Fn Lock Mode so that you don't have to press Fn with the the function keys.Ĭheckout our post on the Best Keyboards for Excel Keyboard Shortcuts to learn more.You might wonder what the 'Formulas' tab on the top navigation toolbar in Excel means. You might also need to press the Fn (function) key in combination with the function keys F1 to F12. Laptop keyboards tend to have smaller keyboards and don't always contain keys like Page Up, Page Down, Menu, etc. If you are using a laptop keyboard then you might be limited on the some of the shortcuts you can press. Press & release Alt, then press & release E, then press & release S. For example, to press the shortcut Alt,E,S to open Paste Special, you will: The, (comma) between keys means press & release each key in order. Press & hold Ctrl, then press & hold Shift, then press L. For example, to press the shortcut Ctrl+Shift+L to Toggle Filters, you will: The + (plus) between keys means press & hold the keys together in order.

There are two ways to press the shortcut keys depending on the separator character used in the sequence.

Formula excel shortcut keys