Once you've found the formula that suits your needs, click 'Insert Function,' as shown in the window above. Want a more sorted browsing experience? Use any of the icons we've highlighted (inside the long red rectangle in the first screenshot above) to find formulas related to a variety of common subjects - such as finance, logic, and more. 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. You might wonder what the 'Formulas' tab on the top navigation toolbar in Excel means.

Excel shortcut keys select all data