ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In Excel spreadsheet what does Ref # mean? (https://www.excelbanter.com/excel-discussion-misc-queries/252656-excel-spreadsheet-what-does-ref-mean.html)

tjwhite1209

In Excel spreadsheet what does Ref # mean?
 
What does Ref # mean in Excel spreadsheet?

Jacob Skaria

In Excel spreadsheet what does Ref # mean?
 
#REF! is a error type which occurs when a cell reference (cell reference: The
set of coordinates that a cell occupies on a worksheet. For example, the
reference of the cell that appears at the intersection of column B and row 3
is B3.) is not valid.

Click the cell that displays the error, click the button that appears , and
then click Trace Error if it appears. Review the possible causes and solutions

(Taken from MSExcel help)

--
Jacob


"tjwhite1209" wrote:

What does Ref # mean in Excel spreadsheet?



All times are GMT +1. The time now is 04:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com