How to bold the text of a header in excel?

[HeartCatcher (Naveenkumar.S)]

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.

[HeartCatcher (Naveenkumar.S)]

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

[Palaniyappan (Palaniyappan P)]

Hi

Did we try with this

How to Make Spesific Excel Rows Bold

Hi everyone, I had asked a question like that before but then something has changed. So i want to ask my question more spesific way this time. I have to make the fonts of some specific rows in an excel file bold. If “Expense” column contains “Total Expense”, I want that rows text to be bold. In addition, the header row should be bold. Is there anyone who tell me how may i create this loop? I know i have to use for each row and if but do not know how to make it. May someone help please? [i…

UiPath Go ! BalaReva EasyExcel Activities

Hi, I have developed some activities to make easy excel automation. Package manage Search keyword: Balareva.easyexcel An activity library that makes Excel automation very easy This package contains activities that will help automate your work with Excel. The below activities are available: ExtractGraphImage - Extracts graphs available in a specific Excel and converts these into images. ExtractHyperLinks - Extracts hyperlinks from a specific cell range within a given Excel sheet. The e…

Cheers @HeartCatcher

[Sudharsan_Ka]

Hi @HeartCatcher

Hope this threads will help you

How to make a particular row in excel bold

@rifnanahas as an alternate option to macro, with UiPath activities it can be done like following: Select Range activity - here we can pass the range dynamic with a variable Send Hotkey Activity - indicating to Excel with the selector Hotkeys for bold: CTRL+2 CTRL+B ( in some cases, depends on language / locals) CTRL+SHIFT+F (local command e.g. for German, similar to the shortcut showing when hovering the Bold format Button in the ribbon menu) Doing it with VBA / Macro: using invoke VBA…

Regards
Sudharsan

[geetishree.rao]

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

[HeartCatcher (Naveenkumar.S)]

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

[geetishree.rao]

Dear Naveen,

What are you getting if you try this out?

Thanks,
Geetishree Rao

[HeartCatcher (Naveenkumar.S)]

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

[geetishree.rao]

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

[Reshma_Shaik (RS)]

How can the same thing be done with Google Sheets, instead of excel?

[Reshma_Shaik (RS)]

How to bold the text of a header or any similar activity in googlesheet?