LearnExcel.io
Menu

Excel Cell References and Ranges

This category demystifies cell references and ranges, a crucial aspect of Excel. Learn about relative, absolute, and mixed references, and how to name and use ranges effectively in your formulas.

30 guides in this section

Start here · Complete guide

Looking Up Data in Excel: The Complete Guide

Master every Excel lookup method—VLOOKUP, XLOOKUP, INDEX MATCH, multi-criteria lookups, cross-sheet pulls, and #N/A fixes—in one definitive guide.

Read the guide →

Latest guides

What Is Absolute Cell Reference in Excel

Learn all about the absolute cell reference in Excel and how to use it to your advantage. Improve your spreadsheet skills and become an Excel pro today!

May 21, 2023

What Is an Absolute Reference in Excel

Learn what an absolute reference is in Excel and how to use it in your formulas. Check out our easy-to-follow guide on absolute referencing in Excel today.

May 21, 2023

How to Change Axis Range in Excel

Learn how to change the axis range in Excel and customize your chart to display only the data you want. Improve your data visualization skills!

May 21, 2023

A Circular Reference in Excel

Learn about circular references in Excel, why they occur, and how to fix them. This blog post provides step-by-step instructions to help you resolve this issue and optimize your Excel spreadsheet.

May 21, 2023

How to Create a Name Range in Excel

Learn how to create a name range in Excel with this step-by-step guide. Organize your data and streamline your workflow efficiently.

May 21, 2023

How to Create Range Names in Excel

Learn how to create range names in Excel with this step-by-step guide. Simplify your formulas and improve your spreadsheet organization.

May 21, 2023

What Is a 3D Reference in Excel?

Learn how to use 3D references in Excel spreadsheets. Find out what 3D references are, how they work, and how they can help simplify your calculations.

May 20, 2023

How to Calculate Range in Excel

Learn how to calculate the range of a set of data in Microsoft Excel with step-by-step instructions. Our guide can help simplify your calculations and improve your data analysis skills.

May 20, 2023

Can’t Find Circular Reference in Excel

Learn how to troubleshoot and resolve circular reference errors in Excel spreadsheets. Our guide helps you find and fix the issue, so you can keep working efficiently.

May 20, 2023

All excel cell references and ranges guides by topic

Reference (15)

Range (9)

More guides (6)

Explore other categories