How to delete all the rows below active cell in Google spreadsheet

Help Studio
, ,
1

Im finding difficulty in selecting all the rows below a selected cell and delete the selected rows below it.

Is there any shortcut to do that?

Any help appreciated.Thanks in advance.

2

Hi @Priyadharshini_Ramulunaid

Try this

  • Use Lookup Datatable and give the cell you need to find
    you can get the row index there and store in a variable “Var_Name”
  • Use Read Range
    Give Range as eg :“A”+Cint(Var_Name+2).ToString
  • Use delete Range and give the Range as above

Hope it Helps

Regards

4

Hi Sudharsan,

Thanks.It worked :slight_smile:

5

Hi,

I am now facing a new issue writing back to spreadsheet using write range activity from where I have deleted rows with below error.

“message”: “Invoke Workflow File: Requested entity was not found. [404]”

6

If possible can you share the screenshot?

7

image
image705Ă—375 13.2 KB

8

Have you included the authentication scope of spreadsheet in application scope?

In this window
image

1 Like
9

Hi Sudharshan,

After checking the scope i am able to write it.Thanks for the help

10

That’s Great
Happy Automation
If you issue solved please mark your Solution

Regards
Sudharsan