listi.net

Listi.net

             


 Scott Kravatz's Microsoft Exce... >

What is Excel #Ref! Error and How to Avoid it



The Excel #Ref! error means there is an unknown reference or address in a cell formula.

There are times where you want to copy and paste cells (ctrl+c) vs. cutting  and paste(ctrl+x). One problem with cutting is that you can create #REF! to an existing formula.

To see this, enter into:
A1 the number 1
A2 =A1+1
Cut A3 and paste to A1
A2 = #REF!

Instead Copy A3 and paste to A1.


blog comments powered by Disqus
Home

Sign In
Sign Up

FAQ
About
Help
Contact Us
Terms and Conditions

Tweet List

Link to us