By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills



Step 292 - $A$1 vs. A$1 vs. $A1 vs. A1


Excel has addressing that is important when you copy a formula.

This addressing goes by the names Relative and Absolute address

A1 Represents column A and row 1.

When you copy or fill a cell that has a formula Excel needs to know what to do with the cells


F4 - shortcut key can be used to toggle a cell from A1 -> $A$1 -> A$1 -> $A1 -> A1


Excel Relative vs. Absolute addressing

Percentage Example

Create a list of numbers and the percent of total that the number comprises

Exercise Multiplication table

Lesson
  • Build a multiplication table hardcoded
  • Build using formulas
  • Build using relative addressing

  •    Table of Contents | Send us your feedback | © 2025 All Rights Reserved | Edit