Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Excel error

Locked

When i copy cells that have an absolute cell reference using autofill i receive green auditing triangles in the top left corner of each cell (that has the answer)that has been copied to. It says there is an error howvere the answers are correct…any ideas

Topic

Reply To: Excel error

In reply to Excel error

Depending on how you set the absolute reference, that might be a bogus or a correct error reference. Take a look at this guide and let us know which absolute cell reference you used in your formula:

http://www.awardsites.com/tutorials/excel/cell_ref-01.htm

Reply To: Excel error

In reply to Excel error

I am using the first example of the absolute cell reference where it shows =B4*$B$10.

Reply To: Excel error

In reply to Excel error

This question was closed by the author

[Author]

Replies