Answer (1 of 2) # is called error It shows when an error in some formulas or something missing in the formula For more shortcuts like this and for building strong I need to know what the #NAME means when it appears in a cell that I have typed a formula in? How to Fix the Excel Errors #VALUE, #REF, and #NAME (Easily) Written by cofounder Kasper Langmann, Microsoft Office Specialist If you have spent much time working with formulas in Microsoft Excel, you have run into a few errors They all have a specific meaning to help you as the user understand what the problem is
The Name Excel Error How To Find And Fix Name Errors In Excel Excelchat