1 Open your saved Excel workbook in Microsoft Excel 16 2 Select a cell where you want to display the name of the file and enter the following formula and press the enter key Mark has a worksheet where he wants to record the name of a user, but rather than asking the user to fill in a form, he wants to automatically grab their username from Excel The username that a person sets in Excel when first installing the software or when changing the general options for the program cannot be accessed via formulaBy default, your text in Excel 16 appears in a black font If you want to change the font color, look for the uppercase A with a colored bar under it in the Font group under the Home tab Select the cells for which you want to change the font color, then click on the button to choose the color you want to apply to the selected text
Ms Excel 16 Add A Named Range