Delete content of columns without deleting header

Help
1

How to Delete content of columns without deleting header in excel

2

Hello @ranjani

Below article might help you

Regards
Ajay

1 Like
3

Hi @ranjani

Do you want to delete the entire row after deleting its contents? or do you only want to remove the content and keep the row?

If you want to delete the row, you can use the Delete range as specified by @Ajju. If you want to delete the content and keep the row, then you might need to use a set of loops to clear out the content.

1 Like
4

Hi
If you want to delete all the records without deleting the columnheader
Use
Clear datatable activity where pass the input as datatable and once this is done we will have the datatable only with headers

For more info on this

Cheers @ranjani

5

Thanks a lot

1 Like
6

No worries
Cheers @ranjani

7

i want to retain a cell value and delete the rest in all rows

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.