Question

how do you turn a range of data in excel and create a table? I do not want to use screen capture if I can help it.

  • 30 April 2022
  • 3 replies
  • 12 views

how do you turn a range of data in excel and create a table? I do not want to use screen capture if I can help it.

3 replies

Userlevel 3
Badge +7

Hi @dean mcghee​ ,

 

You can use the Excel Advanced: Select Rows/Columns/Cells Action toggled to Cell, pass in the required range and then use a Simulate Keystrokes: [Ctrl Down]t[Ctrl Up] :

image 

Kind Regards,

Ashwin A.K

 

Userlevel 4
Badge +8

@dean mcghee​ :

 

if you are still facing an issue then please create a support case

 

How to create a support case :

https://apeople.automationanywhere.com/s/article/How-to-create-a-support-case-in-service-cloud

 

if you don't have access to the above link, email the AA Support team "apeopleopsteam@automationanywhere.com" to get access.

Badge

Hi @dean mcghee​ ,

 

You can use the Excel Advanced: Select Rows/Columns/Cells Action toggled to Cell, pass in the required range and then use a Simulate Keystrokes: [Ctrl Down]t[Ctrl Up] :

image 

Kind Regards,

Ashwin A.K

 

If I want to filter the table that I created like this, it wont be able to find the table:

Any suggestions? 

 

Reply