How to bold only the first line or first word in cell in Excel?

When working with text in Excel, you may need to emphasize specific parts of the content within cells for better readability or presentation. For example, you might want to bold only the first line of text in a multi-line cell or highlight just the first word. In this article, we’ll explore various methods to bold only the first line or first word in Excel cells, catering to different levels of expertise and requirements.

Bold only the first line in cell using VBA code

Bold only the first word in cell using VBA code

Bold only the first word or first line in cell using Kutools AI

Bold only the first line in cell using VBA code

The following VBA code can help you quickly bold only the first line in selected cells. Please do as follows.

1. Press "Alt" + "F11" keys simultaneously to open the "Microsoft Visual Basic for Applications" window.

2. In the "Microsoft Visual Basic for Applications" window, click "Insert" > "Module". Then copy and paste the below VBA code into the Module window.

VBA code: Bold only the first line in cells

Option Explicit
Sub BoldFirstLine()
Dim xRng As Range, xCell As Range
Dim xFirstRow As String
On Error Resume Next
Set xRng = Application.InputBox("Please select range：", "Kutools for", Selection.Address, , , , , 8)
If xRng Is Nothing Then Exit Sub
On Error Resume Next
For Each xCell In xRng
    With xCell
        .Characters(1, InStr(.Value, Chr(10))).Font.Bold = True
    End With
Next
End Sub

3. Press the "F5" key to run the code. Then a "Kutools for Excel" dialog box pops up, please select the range with the first line you need to make it bold, and then click the "OK" button.

Then you can see all first lines of selected cells are bold immediately as below screenshot shown.

Bold only the first word in cell using VBA code

As below screenshot shown, sometimes, you need to bold the first word only in range A2:A4 in Excel. You can achieve it as follows step by step.

1. Press "Alt" + "F11" keys simultaneously to open the "Microsoft Visual Basic for Applications" window.

2. In the "Microsoft Visual Basic for Applications" window, click "Insert" > "Module". Then copy and paste the below VBA code into the Module window.

VBA code: Bold only the first word in cells

Sub boldtext()
Dim xRng As Range, xCell As Range
On Error Resume Next
Set xRng = Application.InputBox("Please select range：", "Kutools fro Excel", Selection.Address, , , , , 8)
If xRng Is Nothing Then Exit Sub
On Error Resume Next
For Each xCell In xRng
  If xCell.Value <> "" Then
    xCell.Characters(1, InStr(1, xCell.Value, " ") - 1).Font.Bold = True
  End If
Next
End Sub

3. Press the "F5" key to run the code. In the popping up "Kutools for Excel" dialog box, select the range which you want to make the first word bold, and then press the "OK" button. See screenshot:

Then you can see all first words of selected cells are bold immediately as below screenshot shown.

Bold only the first word or first line in cell using Kutools AI

If you find VBA code too complex, you can use "Kutools AI" for a simpler and more efficient solution. With Kutools for Excel AI, you can automate this task and apply consistent formatting in just a few clicks. Whether you’re working with small datasets or large spreadsheets, "Kutools AI" saves time and ensures a polished result.

After installing Kutools For Excel, please click "Kutools" > "AI Aide" to open the "Kutools AI Aide" pane.

1. Select the data range that you want to remove text within parentheses;
2. Then, type the requirement in the chat box: such as:
   ● Bold first word of each cell:
   Bold only the first word in the selected range
   ● Bold first line of each cell
   Bold only the first line in each cell within the selected range
3. And then, press "Enter" key or click the "Send" button. Kutools AI will analyze the question, after finishing, please click "Execute" button to get the result.

Bolding the first line or first word in an Excel cell can significantly enhance the visual appeal and clarity of your data. Choose the approach that best fits your workflow and elevate the presentation of your Excel data! If you're interested in exploring more Excel tips and tricks, our website offers thousands of tutorials.

Related article:

• How to delete all blank lines or only the first line in cell in Excel?