Click Entering Absolute Cell References into a Formula

  • Thread starter Thread starter Michael Karas
  • Start date Start date
M

Michael Karas

When one is in the process entering a formula into an
EXCEL spreadsheet it is possible to click on another cell
to automatically have this cell reference placed into the
formula. However this entry always is entered as a
RELATIVE cell reference. Is there a way to have EXCEL
insert an ABSOLUTE cell reference into the formula??

It seems to me that it would be so common and yet I have
never been able to figure this one out.

Please Help
Michael Karas
 
Hi Michael!

Is this what you want?

Click the cell and then press F4.

F4 acts as a toggle going through the four reference options.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Friday 18th July: Mexico (Day of Mourning
death of Benito Juarez), Spain (Labor Day), Uruguay (Constitution Day)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Well....that works great. All along (for years actually) I
knew there had to be _SOME WAY_ to do this but could never
discover it in on-line the documentation. Instead I had
always tried things like CTL-LfClick, CTL-ALT-LfClick etc
etc etc all to NO avail.

Thanks for the quick and excellent response!!!!
Michael Karas
 
Hi Michael!

I did a search in Help for Excel 2002 using "absolute reference",
"relative reference" and "reference" as search strings and it is there
under "Switch between relative, absolute and mixed references".

Under contents it is:

Creating and correcting formulas > Using References > Switch between
relative, absolute and mixed references

But searching in Help is not the most user friendly or easiest to get
results from at times.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Friday 18th July: Mexico (Day of Mourning
death of Benito Juarez), Spain (Labor Day), Uruguay (Constitution Day)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top