Hi,
I want to do autofit for specific columns and bold for header column, how can i do that using uipath?
Hi,
I want to do autofit for specific columns and bold for header column, how can i do that using uipath?
Hi,
Try in Excel scope, put send hot keys) allways works)
@Vladokrash thanks but i tried it is not working, do you know the keystrokes for autofit columns?
try this, use Excel scope, check in properties visible, select range with activity, then put hot keys βalt+hβ, them βo, iβ.
thank you
I have a lot of success using TypeInto with the hotkey combinations, and itβs super fast; you can also combine combos, like rename sheet and type in the sheet name in one line.
Examples,
TypeInto β[k(alt)]horName[k(enter)]β
Select Range β¦ TypeInto β[k(alt)hoi[k(alt)]h1β
Can do both actions in one line too.
To find further key combos, just press the Alt key in Excel and youβll see the characters popup in the menu.
@ClaytonM thanks for the response, can i know what will be used for bolding the first col in excel?
Hi,
You need to Select the column, then use the key combination (which you can find by pressing the Alt key followed by the characters that display on the menu ribbon bar)
For example,
Select Range βA:Aβ
TypeInto β[k(alt)]h1β
That should highlight column A then do the combination for Bold.
Regards.
Hi,
How to do autofit for entire coloumn for excel using uipath?