Addressing Techniques

V

virendra

I want to know the different addressing techniques used in MS Excel.. Can
anybody help me out?
 
J

JLatham

Lots of ground to cover by that seemingly simple question. I think the best
place to start is probably in Excel's Help - look for topics such as
'Addressing', 'Cell Reference' and 'Named Ranges' or 'Names'.

If you could be more specific in your request, we might be able to be more
helpful.

There is relative cell addressing, absolute cell addressing, addressing
using functions such as INDIRECT() and OFFSET() and more.
 
A

Arvi Laanemets

Hi

A1 or R1C1 reference style;
Reference to range or to cell or to named range;
Reference to range/cell on same sheet/another sheet/another workbook;
Absolute or relative reference (separately for rows and columns).
Combinations;
Functions/features returning cell/range reference:
Worksheet: OFFSET(),INDEX(),INDIRECT()
VBA: Range(), Cell(), Names(), [NamedRange]
 
Top