Code Name | search
Click here to view Code Name news from 60+ newspapers.
Bookmark or Share- Use the Name Manager in Excel - Microsoft SupportUse the Name Manager dialog box to work with all the defined names and table names in a workbook. For example, you may want to find names with errors, confirm the value and reference of a name, view or edit descriptive comments, or determine the scope.
- How to correct a #NAME? error - Microsoft SupportThe top reason why the #NAME? error appears in your formula is because there is a typo in the formula name. To avoid typos in formula names, use the Formula Wizard in Excel.
- Insert the current Excel file name, path, or worksheet in a cellInsert the current file name, its full path, and the name of the active worksheet. Type or paste the following formula in the cell in which you want to display the current file name with its full path and the name of the current worksheet: =CELL ("filename")
- Insert ASCII or Unicode Latin-based symbols and charactersASCII and Unicode character encoding enables computers to store and exchange data with other computers and programs. Below are lists of frequently used ASCII and Unicode Latin-based characters. For Unicode characters for non-Latin-based scripts, see Unicode character code charts by script.
- Create custom functions in Excel - Microsoft SupportTo use a custom function, the workbook containing the module in which you created the function must be open. If that workbook is not open, you get a #NAME? error when you try to use the function. If you reference the function in a different workbook, you must precede the function name with the name of the workbook in which the function resides.
More
