It’s doable, but you would lose your formula, which might not be a problem if the you are using is a template. Open the template that contains the formula, enter your values, run the macro and then save the sheet under a different name. Of course, none of that matters since you don’t want to use VBA. The only other option I can think of is to split your formula into multiple cells so that the DOLLAR function is in a cell by itself.
#HOW TO ADD A UNDERLINE IN EXCEL HOW TO#
How to add blank underline in excel code To underline just a portion of the contents in a cell, double-click that cell, and then select the text or numbers that you want to underline. Once that is done, you can simply bold that cell.Ĭlick Here Before Posting Data or VBA Code -> How To Post Data or Code.Īs far as I know, it can’t be done in a single cell without VBA and even then it would be troublesome.The Characters object, which can be used to set the font style for specific characters in a cell that contains a text string, will not recognize text within a formula. #How to make an underline in excel how to# Re: add underline based on empty rows hello Try following code: this code adds border line to rows from selection range if next row is blank. #How to make an underline in excel code#.#How to make an underline in excel how to#.
0 kommentar(er)
