Excel Glossary: 100+ Excel Terms Every Beginner Should Know

Have you ever been learning Excel and come across words like Workbook, Worksheet, PivotTable, or Conditional Formatting?

If you’re a beginner, these terms can be confusing at first.

You may know what you want to do in Excel, but sometimes it’s the terminology that makes things difficult.

Don’t worry. Every Excel user starts the same way.

The good news is that you don’t have to memorize hundreds of Excel terms all at once.

As you continue learning and practicing, you’ll naturally become familiar with them.

This glossary explains more than 100 common Excel terms in simple English, making it easier to understand Excel tutorials, follow step-by-step guides, and use different Excel features with confidence.

Whether you’re a student, office worker, business owner, or someone learning Excel for the first time, you can use this page as a quick reference whenever you come across a new or unfamiliar Excel term.

Let’s get started.

What Is an Excel Glossary?

An Excel glossary is a collection of common Excel words and their meanings.

Instead of searching online every time you come across an unfamiliar Excel term, you can use this glossary to quickly understand what it means.

From basic terms like Cell and Workbook to advanced features like PivotTable, XLOOKUP, and Conditional Formatting, this guide explains everything in simple, beginner-friendly language.

You don’t need to read it from beginning to end.

Simply bookmark this page and come back whenever you need a quick explanation of an Excel term.

A

Active Cell:

Have you ever clicked on a cell before typing something in Excel?

The cell you click becomes the Active Cell.

It’s the cell where you can enter, edit, or delete data. You’ll know it’s active because Excel highlights it with a thick border.

For example, if you click on B5, cell B5 becomes the active cell.

Almost everything you do in Excel starts with selecting the active cell.

Related Article: What Is an Active Cell in Excel?

Alignment:

Sometimes the text inside a cell doesn’t appear exactly where you want it.

That’s where Alignment comes in.

Alignment controls how the content is positioned inside a cell.

For example, you can align text:

To the left
In the center
To the right
At the top
In the middle
At the bottom

Using the right alignment makes your worksheet look cleaner and easier to read.

Related Article: Cell Alignment in Excel

Auto Calculate:

Imagine you’ve selected a list of numbers and want to know the total without writing a formula.

Excel can do this automatically.

This feature is called Auto Calculate.

When you select a range of numbers, Excel displays quick calculations like:

Sum
Average
Count
Minimum
Maximum

You can usually find these results on the Status Bar at the bottom of the Excel window.

AutoFill:

Have you ever typed January in one cell and wanted Excel to fill the remaining months automatically?

That’s exactly what AutoFill does.

AutoFill helps you quickly copy data, formulas, dates, numbers, or patterns into nearby cells.

Simply drag the Fill Handle at the bottom-right corner of the selected cell, and Excel continues the pattern for you.

It can save a lot of time when working with repeated data.

Related Article: Excel AutoFill: What It Is and How to Use It.

AutoFit:

Sometimes the text inside a cell is too long, and part of it gets hidden.

Instead of adjusting the column width manually, you can use AutoFit.

AutoFit automatically changes the width of a column or the height of a row so that all the content becomes visible.

It’s one of the quickest ways to make your worksheet look neat.

AutoSum:

If you need to add several numbers together, you don’t always have to type the SUM formula yourself.

Excel provides a feature called AutoSum.

With a single click, Excel automatically inserts the SUM function and selects the range of numbers for you.

For example, if your sales figures are in cells B2:B10, AutoSum usually inserts:

=SUM(B2:B10)

This is one of the most useful features for beginners.

Absolute Cell Reference:

When you copy a formula to another cell, Excel normally changes the cell references automatically.

But sometimes you want a reference to stay exactly the same.

That’s when you use an Absolute Cell Reference.

An absolute reference uses the $ symbol.

For example:

=$A$1

No matter where you copy the formula, Excel will always refer to cell A1.

Absolute references are commonly used in calculations involving fixed values such as tax rates or discounts.

Related Article: Absolute Cell Reference in Excel

B

Backspace Key:

Have you ever typed the wrong character while entering data in Excel?

Instead of deleting the entire cell, you can simply press the Backspace key.

The Backspace key deletes one character at a time to the left of the cursor while you’re editing a cell.

For example, if you’re typing Exlcell by mistake, you can press Backspace to remove the incorrect letters without starting over.

Remember, the Backspace key only works when you’re editing a cell. If you’re not in edit mode, it doesn’t clear the cell contents.

Border:

Borders are lines that you can add around cells.

They help separate data and make tables easier to read.

For example, instead of having plain numbers on your worksheet, you can add borders to create a professional-looking table.

Excel provides several border styles, including:

Bottom Border
Top Border
Left Border
Right Border
All Borders
Thick Border

Borders improve the appearance of reports without changing the data itself.

Bold:

Sometimes you want certain text to stand out.

For example, headings, totals, or important values.

Instead of changing the font size, you can make the text Bold.

Bold formatting makes the selected text appear darker and thicker.

You can apply bold formatting by pressing:

Ctrl + B

It’s one of the most commonly used formatting options in Excel.

Related Article: Bold Keyboard Shortcut in Excel

Blank Workbook:

When you open Excel and choose Blank Workbook, Excel creates a new empty file where you can start entering your own data.

Think of it as opening a brand-new notebook before you begin writing.

A blank workbook usually contains one or more empty worksheets, depending on your Excel version.

It’s the starting point for creating reports, budgets, invoices, attendance sheets, and many other spreadsheets.

C

Cell:

Every worksheet in Excel is made up of thousands of small rectangular boxes.

These boxes are called Cells.

A cell is where you enter information such as:

Text
Numbers
Dates
Formulas

Each cell has its own unique address based on its row and column.

For example, the very first cell in a worksheet is A1.

Whenever you type something in Excel, you’re typing inside a cell.

Cell Address:

Every cell in Excel has its own unique address.

This is called the Cell Address.

A cell address is created by combining:

The column letter
The row number

For example:

These addresses help Excel identify exactly which cell you’re referring to in formulas and functions.

Cell Reference:

A Cell Reference tells Excel where to find data.

Instead of typing values directly into formulas, you usually refer to cells by their addresses.

For example:

=A1+B1

This formula adds the values stored in cells A1 and B1.

Using cell references makes formulas easier to update because Excel automatically uses the latest values.

Related Article: Cell References in Excel

Chart:

Numbers can sometimes be difficult to understand by simply looking at a table.

A Chart turns those numbers into a visual representation.

Charts help you compare data, identify trends, and present information more clearly.

Excel offers many types of charts, including:

Column Chart
Bar Chart
Line Chart
Pie Chart
Area Chart
Scatter Chart

Choosing the right chart makes your reports much easier to understand.

Clipboard:

Whenever you copy or cut something in Excel, it doesn’t disappear.

Instead, Excel temporarily stores it in a place called the Clipboard.

When you press Ctrl + V, Excel takes the stored data from the Clipboard and pastes it into the selected location.

The Clipboard makes it easy to copy and move information around your workbook.

Related article: Using the Clipboard in Microsoft Word and Excel

Column:

A Column is a vertical group of cells in a worksheet.

Columns are identified using letters.

For example:

Column A
Column B
Column C

As you move to the right, the column letters continue as AA, AB, AC, and so on.

Columns are commonly used to organize related information, such as names, dates, or sales figures.

Related Article: Rows and Columns in Excel

Conditional Formatting:

Have you ever wanted Excel to automatically highlight important values?

That’s exactly what Conditional Formatting does.

It changes the appearance of cells based on rules that you define.

For example, you can:

Highlight marks above 90 in green.
Show negative values in red.
Display data bars or color scales.
Highlight duplicate values.

Conditional Formatting helps you spot trends and important information much more quickly.

Related Article: Conditional Formatting in Excel

Copy:

Instead of typing the same information again, you can simply copy it.

The Copy feature creates an exact duplicate of the selected data while leaving the original unchanged.

You can copy:

Text
Numbers
Formulas
Images
Tables
Formatting

The keyboard shortcut for Copy is:

Ctrl + C

Related Article: Copy and Paste in Excel

Ctrl Key:

The Ctrl (Control) key is one of the most frequently used keys in Excel.

It works together with other keys to perform shortcuts that save time.

Some popular Ctrl shortcuts include:

Ctrl + C – Copy
Ctrl + V – Paste
Ctrl + X – Cut
Ctrl + Z – Undo
Ctrl + S – Save
Ctrl + F – Find

Instead of searching through menus, you can use Ctrl shortcuts to complete common tasks much faster.

Cut:

The Cut feature removes selected data from its original location so you can move it somewhere else.

Unlike Copy, Cut doesn’t leave the original data behind.

The keyboard shortcut for Cut is:

Ctrl + X

After cutting the data, press Ctrl + V to paste it into a new location.

Related Article: Cut in Excel

D

Dashboard:

Have you ever seen a worksheet that shows charts, numbers, and summaries all on one screen?

That’s called a Dashboard.

A dashboard helps you see the most important information at a glance without scrolling through hundreds of rows of data.

For example, a sales dashboard might show:

Total Sales
Monthly Revenue
Best-Selling Product
Sales by Region
Charts and Graphs

Dashboards are commonly used by managers and business owners to monitor performance.

Data:

Everything you enter into Excel is called Data.

Data can include:

Text
Numbers
Dates
Currency
Percentages
Formulas

For example, if you’re creating a student marks sheet, the student names, marks, and grades are all considered data.

Excel helps you organize, analyze, and present this data efficiently.

Related Article: Data Entry and Editing in Excel

Data Analysis:

Data Analysis means examining your data to find useful information.

For example, you might want to know:

Which product sold the most?
Which student scored the highest marks?
Which month had the highest sales?

Excel provides many tools for analyzing data, including:

Sort
Filter
PivotTables
Charts
Formulas
AI tools like Microsoft Copilot

Related Article: How to Analyze Excel Data Using AI

Data Validation:

Sometimes you want users to enter only certain types of data into a cell.

That’s where Data Validation comes in.

It allows you to control what can be entered into a cell.

For example, you can:

Create a drop-down list.
Allow only numbers.
Restrict dates to a specific range.
Prevent duplicate entries.

Data Validation helps reduce mistakes and keeps your worksheet accurate.

Date Format:

Excel stores dates as numbers but displays them in a readable format.

This display style is called the Date Format.

For example, the same date can appear as:

01/01/2026
January 1, 2026
1-Jan-26
2026-01-01

You can easily change the date format without changing the actual value.

Related Articles:

Effective Date Formatting Techniques in Excel

Easy Keyboard Shortcut for Adding the Current Date in Excel

Delete:

The Delete option removes the contents of selected cells.

You can delete:

Text
Numbers
Formulas
Formatting
Entire rows
Entire columns

If you only want to remove the data while keeping the cell, press the Delete key on your keyboard.

Duplicate Values:

Duplicate Values are entries that appear more than once in your worksheet.

For example, if the same customer name appears twice, Excel considers it a duplicate.

Excel can quickly highlight duplicate values using Conditional Formatting or remove them using the Remove Duplicates feature.

This is useful when cleaning large datasets.

Related Article: Remove Duplicates in Excel

E

Edit Cell:

Need to change the contents of a cell?

You can simply edit it.

Double-click the cell or press F2 to edit the existing data without deleting it.

This is much faster than typing everything again.

Enter Key:

The Enter key is one of the most commonly used keys in Excel.

After entering data into a cell, press Enter to confirm the entry.

By default, Excel moves the active cell one row down after you press Enter.

The Enter key is also used to complete formulas and finish editing a cell.

Esc Key:

The Esc (Escape) key is used to cancel the current action in Excel.

For example, if you’re editing a cell and decide not to save your changes, simply press Esc.

The Esc key can also close menus, dialog boxes, and cancel copy mode after you’ve copied data.

It’s a useful key whenever you want to stop an action without making changes.

Related Article: Cancel Edit in Excel Using Esc Key

Excel Formula:

An Excel Formula is an expression that performs calculations using numbers, cell references, or functions.

Every formula starts with an equal sign (=).

For example: =A1+B1

This formula adds the values in cells A1 and B1.

Formulas are one of the most powerful features in Excel.

Related Article: Basic Excel Formulas for Beginners

Excel Function:

A Function is a predefined formula built into Excel.

Instead of writing long calculations yourself, you can use functions like:

Functions make calculations easier and save time.

Related Article: Advanced Functions in Excel – Complete Guide

Error Value:

Sometimes a formula doesn’t work as expected.

Instead of a result, Excel displays an Error Value.

Some common errors include:

DIV/0!
VALUE!
NAME?
REF!
N/A

These errors usually indicate that something in the formula needs to be corrected.

Don’t worry. They’re very common, especially when you’re learning Excel.

Excel Table:

An Excel Table is a special way of organizing your data.

Unlike a normal range of cells, a table automatically adds useful features like:

Filter buttons
Alternate row colours
Structured references
Automatic expansion when adding new data

Tables make it much easier to manage and analyze information.

F

Fill Handle:

Have you ever noticed the tiny square at the bottom-right corner of a selected cell?

That’s called the Fill Handle.

You can drag it to:

Copy formulas
Continue number series
Fill dates
Repeat text
Extend patterns

It’s one of the easiest ways to save time in Excel.

Filter:

Imagine you have a worksheet with 10,000 rows of data.

Finding one customer manually would be difficult.

That’s where Filter helps.

Filter displays only the rows that match your selected criteria while temporarily hiding the rest.

For example, you can filter:

Only Sales above ₹10,000
Only employees from Hyderabad
Only products in Stock

Filtering doesn’t delete any data. It simply helps you view the information you need.

Flash Fill:

Flash Fill is one of Excel’s smartest features.

It recognizes patterns in your data and completes the remaining entries automatically.

For example, if you have:

John Smith
Ram Kumar

and you type only the first names in another column:

John

Ram

Excel can automatically fill the remaining first names.

Flash Fill saves a lot of time when cleaning or formatting data.

Font:

A Font controls how your text looks in Excel.

You can change:

Using different fonts helps make your worksheets easier to read and more attractive.

Footer:

A Footer is information that appears at the bottom of every printed page.

Common footer items include:

Page numbers
Date
File name
Sheet name
Company name

Footers are mainly used when printing Excel worksheets.

Format:

Formatting changes the appearance of your worksheet without changing the actual data.

For example, you can change:

Font
Colour
Borders
Alignment
Number format
Cell styles

Good formatting makes your worksheet look clean, professional, and easier to understand.

Related Article: Mastering Excel Formatting:

Formula:

A Formula tells Excel what calculation to perform.

Every formula begins with an equal sign (=).

For example:

=SUM(B2:B10)

This formula adds all the numbers from cells B2 to B10.

Formulas allow Excel to perform calculations automatically, making them one of the most important features in the application.

Formula Bar:

Have you ever clicked on a cell and noticed a long box just above the worksheet?

That’s the Formula Bar.

It displays the contents of the active cell.

You can also use it to:

Enter formulas
Edit formulas
View long text
Modify cell contents

The Formula Bar is especially useful when working with complex formulas.

Related Article: Formula Bar in Excel

Freeze Panes:

When working with large worksheets, it’s easy to lose sight of your headings as you scroll.

The Freeze Panes feature keeps selected rows or columns visible while you move through the rest of the worksheet.

For example, you can freeze the first row so that your column headings remain visible even when you scroll down thousands of rows.

This makes large datasets much easier to read.

G

Go To:

Have you ever worked with a large worksheet and needed to jump directly to a specific cell?

Instead of scrolling endlessly, you can use the Go To feature.

Go To lets you quickly move to a particular cell, range, worksheet, or even special cells like blanks and formulas.

For example, if you want to go directly to cell Z250, simply open Go To, type Z250, and Excel takes you there instantly.

Keyboard Shortcut: Ctrl + G or F5

Gridlines:

When you open a new Excel worksheet, you’ll notice faint grey lines separating all the cells.

These are called Gridlines.

Gridlines help you identify rows and columns more easily while entering data.

They are displayed on the screen by default but usually don’t print unless you choose to print them.

Group:

If your worksheet contains a lot of data, you can use Group to organize it.

Grouping allows you to collapse or expand rows and columns, making large worksheets easier to read.

For example, if you have monthly sales data, you can group all the monthly rows and hide them whenever you don’t need to see them.

H

Header:

A Header is information that appears at the top of every printed page.

You can use it to display details such as:

Report title
Company name
Date
Page number
File name

Headers help make printed reports look more professional.

Hide:

Sometimes you don’t want to delete data, but you also don’t want it to appear on the screen.

In that case, you can Hide rows, columns, or worksheets.

Hidden data isn’t deleted. It simply becomes invisible until you unhide it again.

This is useful when working with large worksheets.

Did You Know?

Many Excel users think Hide and Delete mean the same thing.

They don’t.

Hide simply makes rows, columns, or worksheets invisible. You can bring them back anytime.
Delete removes the data completely.

If you’re not sure whether you’ll need the data later, it’s usually safer to hide it instead of deleting it.

Home Tab:

The Home Tab is the first tab you’ll see when you open Excel.

It contains many of the tools you’ll use every day, including:

Copy and Paste
Font Formatting
Alignment
Number Formatting
Styles
Cells
Editing tools

If you’re new to Excel, most of your work will begin from the Home tab.

Related Article: Ribbon in Excel

Hyperlink:

A Hyperlink is a clickable link that takes you to another location.

For example, a hyperlink can open:

Another worksheet
Another workbook
A website
An email address
A document

Hyperlinks make it easy to connect related information.

Keyboard Shortcut: Ctrl + K

I

IF Function:

The IF function is one of the most popular functions in Excel.

It allows Excel to make simple decisions based on a condition.

For example:

If marks are greater than 35, display Pass.

Otherwise, display Fail.

Example:

=IF(B2>=35,”Pass”,”Fail”)

The IF function is widely used in reports, grading systems, attendance sheets, and business calculations.

Insert:

The Insert option allows you to add new items to your worksheet.

For example, you can insert:

Rows
Columns
Cells
Charts
Tables
Pictures
Shapes

Instead of recreating your worksheet, you can simply insert the items you need.

Insert Function:

Not sure which function to use?

Excel provides an Insert Function feature to help you.

It lets you search for functions based on what you want to calculate.

For example, if you type average, Excel suggests functions related to averages.

This is especially useful for beginners who don’t remember every function.

Keyboard Shortcut: Shift + F3

L

Left Align:

Left Align places the contents of a cell against the left side.

By default, text in Excel is usually left-aligned.

You can change the alignment whenever needed.

Related Article: Cell Alignment in Excel

Line Chart:

A Line Chart displays data using connected lines.

It’s commonly used to show changes over time.

For example:

Monthly sales
Daily temperatures
Website visitors
Stock prices

If you want to identify trends, a Line Chart is often one of the best choices.

Lookup:

A Lookup means searching for information in a table.

Excel provides several lookup functions, including:

XLOOKUP
VLOOKUP
HLOOKUP

These functions help you find related information quickly without searching manually.

For example, you can look up an employee’s salary using their Employee ID.

Logical Function:

Logical Functions allow Excel to make decisions.

Some common logical functions include:

These functions are useful when you want Excel to return different results based on conditions.

Lock Cell:

Sometimes you want to prevent users from editing certain cells.

You can do this by locking the cells.

Locked cells cannot be edited once worksheet protection is enabled.

This is useful when sharing templates or reports with others.

Lowercase:

The LOWER function converts all uppercase letters into lowercase letters.

For example:

If cell A1 contains:

`MICROSOFT EXCEL`

The formula:

`=LOWER(A1)`

returns:

`microsoft excel`

This is useful when cleaning or standardizing text.

M

Macro:

Have you ever found yourself repeating the same steps in Excel again and again?

For example:

Formatting reports
Copying data
Creating the same table every day

Instead of doing these tasks manually every time, you can record them as a Macro.

A Macro is a series of recorded actions that Excel can replay with a single click.

Macros are especially useful for repetitive tasks and can save a lot of time.

Merge Cells:

Sometimes you want a title to stretch across several columns instead of appearing in just one cell.

That’s where Merge Cells comes in.

Merge Cells combines two or more adjacent cells into one larger cell.

It’s commonly used for:

Report titles
Table headings
Dashboard headings

Excel offers different merge options such as:

Merge & Center
Merge Cells
Merge Across
Unmerge Cells

MIN Function:

The MIN function returns the smallest number in a selected range.

For example:

If cells B2:B6 contain:

25, 40, 18, 62, 30

The formula:

`=MIN(B2:B6)`

returns:

It’s commonly used to find the lowest sales, minimum marks, or smallest value in a dataset.

Related Article: MIN Function in Excel

MAX Function:

The MAX function does the opposite of the MIN function.

It returns the largest number in a selected range.

For example:

`=MAX(B2:B6)`

returns the highest value from the selected cells.

This function is useful when finding the highest sales, top score, or maximum value.

Related Article: MAX Function in Excel

N

Name Box:

Look just above your worksheet, to the left of the Formula Bar.

You’ll see a small box showing something like A1.

This is called the Name Box.

It displays the address of the currently selected cell.

You can also use it to:

Jump directly to a cell.
Select a range.
Create Named Ranges.

Many beginners overlook the Name Box, but it’s a very useful navigation tool.

Related Article: Name Box in Excel

Named Range:

Instead of referring to a range as:

A2:A20

you can give it a meaningful name like:

Sales

Marks

This is called a Named Range.

Using named ranges makes formulas easier to read and understand.

For example:

Instead of:

`=SUM(A2:A20)`

you could write:

`=SUM(Sales)`

This makes formulas much easier to understand, especially in large workbooks.

Number Format:

Numbers don’t always have to look the same.

Excel lets you display numbers in different formats such as:

Currency
Percentage
Date
Time
Decimal
Fraction
Accounting

Changing the number format only affects how the value is displayed.

It doesn’t change the actual value stored in the cell.

Related Article: Number Formatting in Excel

O

Office Clipboard:

The Office Clipboard stores multiple copied items instead of just one.

This means you can copy several pieces of data and paste them later without copying again.

It’s especially useful when working with large reports.

Orientation:

When printing a worksheet, you can choose how the page should be displayed.

This is called Page Orientation.

Excel provides two options:

Portrait (Vertical)
Landscape (Horizontal)

Landscape is commonly used for wide tables and reports.

P

Paste:

After copying or cutting data, you use Paste to place it in another location.

The keyboard shortcut is:

Ctrl + V

Paste works with:

Text
Numbers
Formulas
Pictures
Charts
Formatting

Related Article: Copy and Paste in Excel

Paste Special:

Sometimes you don’t want to paste everything.

For example, you may want to paste:

Only values
Only formulas
Only formatting
Only column widths

That’s when you use Paste Special.

It gives you much more control over how your copied data is pasted.

Keyboard Shortcut:

Ctrl + Alt + V

PivotChart:

A PivotChart is a chart that’s connected to a PivotTable.

When you filter or update the PivotTable, the PivotChart updates automatically.

This makes it easier to visualize summarized data.

PivotCharts are commonly used in dashboards and business reports.

PivotTable:

A PivotTable is one of the most powerful tools in Excel.

It helps you summarize large amounts of data without writing complex formulas.

For example, you can quickly find:

Total Sales
Average Sales
Highest Sales
Sales by Region
Sales by Product

Simply, drag and drop fields to analyze your data from different angles.

If you work with large datasets, learning PivotTables can save you a lot of time.

Related Article: Pivot Tables in Excel

Power Query:

Power Query is a tool used to import, clean, and transform data.

Instead of editing data manually every time, you can create a series of steps that Power Query remembers and repeats automatically.

It’s especially useful when working with data from:

Excel files
CSV files
Databases
Websites

Power Query is a popular tool for data preparation and reporting.

Print Area:

Sometimes you don’t want to print the entire worksheet.

Instead, you only want to print a specific section.

The Print Area feature lets you choose exactly which cells should be printed.

This helps save paper and keeps printed reports focused on the information you need.

Protect Sheet:

If you’re sharing an Excel worksheet with others, you may want to prevent accidental changes.

The Protect Sheet feature allows you to lock the worksheet so that users can’t edit certain cells or make unwanted changes.

You can even protect the sheet with a password for added security.

Percentage Format:

The Percentage Format displays numbers as percentages.

For example:

If a cell contains:

`0.25`

Excel can display it as:

25%

This format is commonly used for discounts, profit margins, tax rates, and growth percentages.

Q

Quick Access Toolbar (QAT):

Have you noticed the small toolbar at the top-left corner of the Excel window?

That’s called the Quick Access Toolbar, often shortened to QAT.

It gives you quick access to your favorite commands without searching through the Ribbon.

By default, it includes commands like:

Save
Undo
Redo

You can also customize it by adding commands such as:

Print Preview
Format Painter
AutoSum
Sort
Filter

If you regularly use the same tools, customizing the Quick Access Toolbar can help you work faster.

Related Article: Quick Access Toolbar in Excel

R

Range:

A Range is a group of one or more selected cells.

For example:

A1:A10
B2:D8
C5:F15

Ranges are commonly used in formulas, charts, tables, and PivotTables.

For example:

=SUM(B2:B10)

Here, B2:B10 is the range.

Redo:

Have you accidentally pressed Undo and wanted to get your change back?

That’s exactly what Redo does.

Redo restores the last action that was undone.

Keyboard Shortcut:

Ctrl + Y

Related Article: Redo Shortcut in Excel

Relative Cell Reference:

By default, Excel uses Relative Cell References.

This means when you copy a formula, Excel automatically changes the cell references based on the new location.

For example:

If cell C2 contains:

`=A2+B2`

and you copy it to C3, Excel changes it to:

`=A3+B3`

This automatic adjustment saves time when working with formulas.

Related Article: Relative Cell References in Excel

Ribbon:

The Ribbon is the large toolbar at the top of the Excel window.

It contains almost every command you’ll use while working in Excel.

The Ribbon is divided into tabs such as:

Home
Insert
Page Layout
Formulas
Data
Review
View

Each tab contains groups of related commands.

For example, the Home tab includes Clipboard, Font, Alignment, Number, Styles, Cells, and Editing groups.

Related Article: Ribbon in Excel

Row:

A Row is a horizontal line of cells in a worksheet.

Rows are identified by numbers such as:

Row 1
Row 2
Row 3

Each row contains multiple cells where you can enter data.

Related Article: Rows and Columns in Excel

How to add and delete Rows in an Excel worksheet?

S

Sheet Tab:

At the bottom of every workbook, you’ll see tabs like:

Sheet1
Sheet2
Sheet3

These are called Sheet Tabs.

They help you switch between different worksheets inside the same workbook.

You can also rename, move, copy, or delete sheet tabs.

Related Article: How to Add and Delete Worksheets in Excel

Shift Key:

The Shift key is another important key used in many Excel keyboard shortcuts.

By itself, it allows you to select multiple cells or extend a selection using the arrow keys.

When combined with other keys, it performs different actions.

For example:

Shift + Space – Select the entire row
Ctrl + Shift + L – Turn filters on or off
Ctrl + Shift + : – Insert the current time

Using the Shift key with other shortcuts can help you work more efficiently.

Sort:

Have you ever wanted to arrange names from A to Z?

Or sales from highest to lowest?

That’s exactly what Sort does.

Sorting organizes your data in a specific order.

Excel lets you sort:

Alphabetically
Numerically
By Date
By Color
By Custom Lists

Sorting makes large datasets much easier to understand.

Status Bar:

Look at the bottom of the Excel window.

You’ll see a bar showing information like:

Ready
Average
Count
Sum
Zoom Level

This is called the Status Bar.

When you select a range of numbers, Excel automatically displays quick calculations here.

Many beginners don’t notice the Status Bar, but it’s a useful feature for quick analysis.

Related Article: Status Bar in Excel

SUM Function:

The SUM function adds numbers together.

It’s one of the first functions most Excel users learn.

For example:

`=SUM(B2:B10)`

This formula adds all the values from cells B2 to B10.

Instead of adding numbers manually, Excel calculates the total instantly.

T

Tab Key:

The Tab key moves the active cell one column to the right.

It’s commonly used when entering data across a row.

For example, after typing a value in one cell, press Tab to move to the next cell on the right.

If you press Shift + Tab, Excel moves the active cell one column to the left.

The Tab key is especially useful for fast data entry.

Text to Columns:

Sometimes all your data is stored in a single column.

For example:

John,Hyderabad,25

Using Text to Columns, Excel can split that information into separate columns.

This feature is useful when importing data from other systems.

Theme:

A Theme is a collection of colors, fonts, and effects that gives your workbook a consistent appearance.

Instead of changing each element individually, you can apply a theme to update the overall look of your workbook.

Themes are useful when creating professional reports or presentations.

U

Undo:

Made a mistake?

Don’t worry.

The Undo feature lets you reverse your most recent action.

Whether you deleted data, entered the wrong value, or formatted a cell incorrectly, Undo can quickly restore the previous state.

Keyboard Shortcut:

Ctrl + Z

Unhide:

If you’ve hidden a row, column, or worksheet, you can make it visible again using Unhide.

Nothing is lost when you hide data.

Unhide simply displays it again.

V

Value:

A Value is the actual information stored in a cell.

It can be:

A number
Text
A date
A time
A formula result

For example, if cell A1 contains the formula:

`=10+20`

the formula is stored in the cell, but the displayed value is 30.

VLOOKUP:

VLOOKUP stands for Vertical Lookup.

It searches for a value in the first column of a table and returns information from another column in the same row.

Although many users now prefer XLOOKUP, VLOOKUP is still widely used.

W

Workbook:

A Workbook is an Excel file.

Think of it like a notebook.

Just as a notebook contains several pages, a workbook can contain multiple worksheets.

For example, a yearly sales workbook may contain separate worksheets for each month.

Related Article: How to Open a New Excel Workbook

Worksheet:

A Worksheet is a single spreadsheet inside a workbook.

It’s where you enter and organize your data.

Each workbook can contain one or many worksheets.

You can rename worksheets, change their order, or add new ones whenever needed.

Related Article: How to Add and Delete Worksheets in Excel

Did You Know?

Many beginners think Workbook and Worksheet are the same.

They’re actually different.

A Workbook is the entire Excel file.
A Worksheet is one sheet inside that workbook.

You can have many worksheets inside a single workbook.

Think of it like this:

📘 Workbook = Book

📄 Worksheet = One Page Inside the Book

This simple comparison makes the difference much easier to remember.

Wrap Text:

Sometimes the text inside a cell is too long to fit within the column.

Instead of making the column wider, you can use Wrap Text.

Wrap Text displays the content on multiple lines within the same cell, making it easier to read.

X

XLOOKUP:

XLOOKUP is one of Excel’s newest lookup functions.

It searches for a value and returns matching information from another column or row.

Compared to VLOOKUP, XLOOKUP is more flexible and easier to use.

For many users, it’s now the preferred lookup function.

Z

Zoom:

The Zoom feature lets you increase or decrease the size of your worksheet on the screen.

Zoom only changes how the worksheet appears.

It doesn’t affect the actual size of your data or how it prints.

You can zoom in to view small details or zoom out to see more of your worksheet at once.

Tips for Learning Excel Terms:

Learning Excel doesn’t mean memorizing hundreds of terms.

Instead, try these simple tips:

Learn a few new terms each week instead of everything at once.
Practice the terms while working in Excel.
Read the related articles to understand each topic in more detail.
Use keyboard shortcuts whenever possible to become faster.

Don’t worry if you forget a term. That’s exactly why this glossary is here.

The more you use Excel, the more natural these terms will become.

AI Tip: Use ChatGPT or Copilot to Learn Excel Terms:

If you don’t understand an Excel term, you don’t always have to search through multiple websites.

You can simply ask an AI tool like ChatGPT or Microsoft Copilot.

For example, you can ask:

Explain the Excel term “PivotTable” in simple English.

Or,

What’s the difference between a Workbook and a Worksheet?

You can even ask AI to provide examples or explain terms using simple language.

AI is a great learning companion, especially if you’re just getting started with Excel.

Commonly Confused Excel Terms:

Some Excel terms sound similar, but they mean completely different things.

Here are a few that beginners often confuse.

Term	Difference
Workbook vs Worksheet	A workbook is the entire Excel file, while a worksheet is a single sheet inside that file.
Formula vs Function	A formula is an expression you create, while a function is a predefined formula built into Excel.
Copy vs Cut	Copy leaves the original data unchanged, while Cut moves the data to a new location.
Cell Address vs Cell Reference	A cell address identifies a cell, while a cell reference is used to refer to that cell in formulas.
Filter vs Sort	Filter temporarily hides unwanted data, while Sort rearranges the order of the data.
Merge Cells vs Center Across Selection	Merge combines cells into one, while Center Across Selection centers text without merging the cells.

Understanding these differences will help you avoid common mistakes while working in Excel.

Frequently Asked Questions (FAQs):

What is an Excel glossary?

An Excel glossary is a collection of common Excel terms explained in simple language. It helps beginners understand the terminology used in Microsoft Excel.

Why should I learn Excel terms?

Understanding Excel terms makes it easier to follow tutorials, use Excel features correctly, and communicate with other Excel users.

Is this glossary suitable for beginners?

Yes.

Every term in this glossary is explained using simple English, making it easy for beginners to understand.

Do I need to memorize all the Excel terms?

No.

There’s no need to memorize everything.

As you continue using Excel, you’ll naturally become familiar with the terms. You can always return to this glossary whenever you need a quick explanation.

How many Excel terms are there?

Microsoft Excel includes hundreds of features, functions, and commands, so there are hundreds of Excel-related terms.

This glossary covers the most common terms that beginners are likely to encounter while learning Excel.

Which Excel terms should I learn first?

If you’re just getting started, focus on learning these basic terms first:

Workbook
Worksheet
Cell
Row
Column
Range
Formula
Function
Ribbon
Formula Bar
Active Cell

Once you’re comfortable with these, learning more advanced Excel features becomes much easier.

Can AI help me understand Excel terms?

Yes.

AI tools like ChatGPT and Microsoft Copilot can explain Excel terms in simple language and provide examples to help you understand them better.

If you’re learning Excel, these beginner-friendly guides may also help:

Learning Excel becomes much easier when you understand the terminology used throughout the application.

Whether you’re creating your first spreadsheet or exploring advanced features like PivotTables and formulas, knowing the meaning of common Excel terms will help you work with more confidence.

Don’t worry if you can’t remember every term right away.

Even experienced Excel users occasionally look up unfamiliar features or commands.

Keep this glossary bookmarked and use it whenever you need a quick explanation.

As you continue practicing Excel, these terms will become familiar, and you’ll find yourself working faster and understanding tutorials much more easily.

Happy learning!