Fixed grid reference, possible?

  • Thread starter Thread starter Beta
  • Start date Start date
B

Beta

I have an application where I need to point absolutely to a fixed cell and
even if the content of that cell gets moved, still the pointer remains on
that cell. As an example suppose I have 1 in the cell A1. Now in the cell A2
I write =$A$1. Of course a 1 is the content of A2. But if now I drag the
content of A1 to B1 the cell A2 now points to =$B$1. What I'm looking for is
a way to have A2 still point at $A$2.
Thanks!
 
I have an application where I need to point absolutely to a fixed cell and
even if the content of that cell gets moved, still the pointer remains on
that cell. As an example suppose I have 1 in the cell A1. Now in the cell A2
I write =$A$1. Of course a 1 is the content of A2. But if now I drag the
content of A1 to B1 the cell A2 now points to =$B$1. What I'm looking for is
a way to have A2 still point at $A$1.
Thanks!
 
Use the INDIRECT function. E.g.,

=INDIRECT("A2")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 2
4 cells with yes, no list 1
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
look to a cell for a reference to a sheet 2
Array Summation in Excel 0
Parsing help requested 3
Turning on data validation in one cell based on the contents ofanother cell 1
LOOKUP function different? 2

Back
Top