Share this article
Improve this guide
How to Add Excel Bold Text in Formulas: 2 Simple Ways
This feature is not supported natively in Excel
2 min. read
Published onSeptember 23, 2024
published onSeptember 23, 2024
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Creating bold text directly within Excel formulas isn’t natively supported. However, you can achieve a similar effect using a combination of formatting and VBA (Visual Basic for Applications). Here’s how to achieve this.
How do I add Excel bold text in a formula?
1. Using VBA to bold text in formulas
2. Using conditional formatting
In conclusion, you can’t insert bold text in formula in the output in Excel without programming. The conditional formatting is, however, a workaround for this conundrum.
We should also mention the manual bold technique. Just click on the cells that contain the text you need to bold and pressCtrl+Bor use theBoldbutton to do that.
If you want to learn how tocreate formulas in Excel using the authoring features, click the highlighted link. We also have a helpful guide onhow to use Ideas in Excel.
For any other questions or suggestions, feel free to use the comments section below.
More about the topics:Microsoft Excel
Claudiu Andone
Windows Toubleshooting Expert
Oldtimer in the tech and science press, Claudiu is focused on whatever comes new from Microsoft.
His abrupt interest in computers started when he saw the first Home Computer as a kid. However, his passion for Windows and everything related became obvious when he became a sys admin in a computer science high school.
With 14 years of experience in writing about everything there is to know about science and technology, Claudiu also likes rock music, chilling in the garden, and Star Wars. May the force be with you, always!
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Claudiu Andone
Windows Toubleshooting Expert
Oldtimer in the tech and science press, with 14 years of experience in writing on everything there is to know about science, technology, and Microsoft
