Relative Reference Archives - Xelplus - Leila Gharani

How to Use Excel Conditional Formatting with Formulas

Leila Gharani — Thu, 03 Dec 2020 10:00:00 +0000

Discover how to properly conditionally format rows in Excel with a Formula. This way you can highlight entire rows. I also share the secret to get it right every time.

The post How to Use Excel Conditional Formatting with Formulas appeared first on Xelplus - Leila Gharani.

How to Properly Reference Cells in Excel – What is the Dollar Sign and When Do you Need it?

Leila Gharani — Sat, 01 Feb 2020 14:35:00 +0000

Properly referencing a cell is THE most important rule you need to master in Excel. Should the reference be relative, absolute or mixed? I explain it all in this quick article.

The post How to Properly Reference Cells in Excel – What is the Dollar Sign and When Do you Need it? appeared first on Xelplus - Leila Gharani.

Excel VBA to Copy Data from one Sheet to Another

Leila Gharani — Thu, 29 Mar 2018 13:26:00 +0000

See how you can use the macro recorder to copy data from one Worksheet to another sheet, appending data from two tabs. Also, learn how to insert a button and assign the macro to it.

The post Excel VBA to Copy Data from one Sheet to Another appeared first on Xelplus - Leila Gharani.

Copy Excel Formulas Without Changing Cell References

Leila Gharani — Mon, 26 Feb 2018 19:31:00 +0000

Would you like to copy your Excel formulas from one place to another without the cell references changing? In this step by step tutorial I show you a very simple trick that does that.

The post Copy Excel Formulas Without Changing Cell References appeared first on Xelplus - Leila Gharani.