Back to Blog
How to add footnote to excel cell6/18/2023 ![]() To avoid confusion, use A1 for reference. ![]() However, if reference is not supplied, CELL will return the name of the current "active sheet" which may or may not be the sheet where the formula exists, and might even be in a different workbook. For certain kinds of information (like filename) the cell address used for reference is optional and can be omitted. If reference refers to more than one cell, CELL returns information about the first cell in reference. ![]() See the table below for a full list of info types. Info_type is a text string that indicates the type of information requested. The CELL function takes two arguments: info_type and reference. See below for a full list of info types and format codes. The type of information returned is given as info_type, which must be enclosed in double quotes (""). CELL can return a cell's address, the filename and path for a workbook, and information about the formatting used in the cell. Use the CELL function to return a wide range of information about a reference.
0 Comments
Read More
Leave a Reply. |