How to bold the text of a header in excel?

Hello Everyone,

I want to BOLD the text of each header in a excel but I am not getting how to do so, please help me to achieve this.
I just want to bold only headers in excel.

Thanks in advance.

@Palaniyappan
@geetishree.rao
@pravin_calvin
@Yoichi
@ppr
@lakshman
@Sudharsan_Ka
@NIVED_NAMBIAR
@THIRU_NANI
please do needful.

1 Like

Hi

Did we try with this

Cheers @HeartCatcher

2 Likes

Hi @HeartCatcher

Hope this threads will help you

Regards
Sudharsan

1 Like

Dear Naveen,
Use Select RangeActivity and specify the header Range.
Then Use Send Hot Key Activity and select Ctrl+B
Please try this out

Thanks,
Geetishree Rao

Thanks for the quick response.
I tried the same but it is not working.

Dear Naveen,

What are you getting if you try this out?

Thanks,
Geetishree Rao

I am not getting the expected output.
Getting same headers without any changes.

Dear Naveen,
Could you try out the below vba code:
Before that please follow the instructions for macro to run:
[UIPath] Error: Programmatic access to Visual Basic Project is not trusted - Surf & Perf (surfandperf.com)

Private Sub FormatHeaders()
Dim ws as Worksheet
For Each ws in Worksheets
ws.Activate
Cells.EntireColumn.Autofit
Cells.EntireRow.Autofit
Rows(“1:1”).Font.Bold = True
Next
Sheets(1).Select
End Sub

Thanks ,
Geetishree Rao

1 Like