FormulaSmith
Free tools
Free step-by-step guides

Guides & tutorials

Clear answers to the spreadsheet questions people actually ask. Each guide starts with the exact fix, then hands you a tool you can run — free, no sign-up, for Excel and Google Sheets.

Answer first, every timeLive tools you can runExcel + Google SheetsNo login, no paywall

Jump straight to a tool

All calculators
CAGR calculatorLoan & mortgagePercentage changeStandard deviationPie-% helper

Finance · 1785

Finance
CAGR Formula ExcelExcel Minus FormulaExcel COUNT DistinctExcel Multiplication Formula
Browse topicFinance

Structure · 2149

Structure
How to Unhide All Rows in ExcelHow to Merge Two Columns in ExcelHow to Unhide Columns in ExcelHow to Unlock Excel Sheet
Browse topicStructure

Charts · 774

Charts
How to Make a Pie Chart in ExcelHow to Make a Line Graph in ExcelHow to Remove Blank Lines in ExcelHow to Make a Histogram in Excel
Browse topicCharts

Text · 712

Text
How to Combine Two Columns in ExcelHow to Wrap Text in ExcelHow to Combine Two Cells in ExcelHow to Combine 2 Columns in Excel
Browse topicText

Data · 1640

Data
How to Remove Duplicates in ExcelHow to Create a Drop Down List in ExcelExcel Drop Down ListHow to Find Duplicates in Excel
Browse topicData

Workflow · 1876

Workflow
Excel Row Insert Shortcut KeyKeyboard Shortcut for Inserting Rows in ExcelMultiple IF Statements in ExcelHow Can We Merge Two Columns in Excel
Browse topicWorkflow

Workspace · 442

Workspace
How to Freeze a Row in ExcelHow to Lock Cells in ExcelHow to Freeze Cells in ExcelHow to Password Protect an Excel File
Browse topicWorkspace