How to unwrap text in whole column

Hi all,

I would like to know how to unwrap data in a whole excel sheet column.

@anonymous3,

You will have to do ui automation for this as below,

  1. Open excel using Excel App Scope and check Visible property of it,
  2. Use Select Range activity and give range for one col like “A1:A20” OR “D2:D100”,
  3. Use Send Hotkey activity Alt+H+W OR you can do it different way as Click Home menu => Click Wrap Text option under Home Menu.

Let us know, if that works for you :slight_smile:

Hi @Pankaj.Patil ,

for part 2, I want to give a range for the whole column as new data will be continuously added. What should I put in " : "

@anonymous3,

It will select entire column. only thing is that you will need to change col name like A or B or C

does this help or i misunderstood you?

A:A e.g. for selecting entire Column A

1 Like

Hi, the send hotkey method does not work for me. Nothing changes in the excel. I check Alt and put H+W in the key box.

@anonymous3,

can you try with this key Alt+hw?
image

Hi @Pankaj.Patil ,

It still does not do anything.

@anonymous3,

Can you attach spreadsheet?
OR
assign spreadsheet selector to this activity.