Excel Glossary
Complete A-Z reference of Excel terms, functions, and features
🔍
A
Absolute Reference
A cell reference that remains fixed when copied to other cells, indicated by dollar signs (e.g., $A$1).
Example:
=$A$1*B2 - A1 stays fixed when copiedRelated: ,
Active Cell
The currently selected cell in a worksheet, highlighted with a bold border.
Example:
The cell where you can enter dataRelated: ,
Array Formula
A formula that performs calculations on multiple values and returns either single or multiple results.
Example:
{=SUM(A1:A10*B1:B10)} - Ctrl+Shift+EnterRelated: ,
AutoFill
Feature that automatically extends a series of values, formulas, or formats.
Example:
Dragging 1, 2 down creates 3, 4, 5...Related: ,
AutoSum
Quick tool to sum a range of cells automatically (Alt + =).
Example:
Automatically adds =SUM(A1:A10)Related: ,
Ready to Learn More?
Put these terms into practice with our comprehensive tutorials