Hello Friends, how is it possible to clear all the content inside an Excel Sheet? I tried with send hotkeys but it didn’t work. How is it possible to delete all the content in this sheet? Movimenti.xlsx (9.5 KB) Thank you so much friends, Camilla. :slight_smile:

The range “A:Z” will type over all rows in those columns. It’s the one I use because it’s more likely that I won’t know how many rows there are, than not know how many columns. Similarly “A2:Z500” will clear that ‘rectangle’ of cells. “2:2” will clear all columns in row 2 only. If I need to leave …

Delete all content in an Excel Sheet

Help

loginerror (Maciej Kuźmicz) June 22, 2018, 6:55am 4

Hi @CamiCat,

You can always try using a short VBA code snippet to clear the entire sheet.

See attached example: ClearAll.zip (1.6 KB)

2 Likes

How to pass a variable to an "Invoke VBA" script?

Topic		Replies	Views
Delete data from Excel Help	5	3643	November 16, 2018
How to clear Excel Sheet using Uipath Studio datatable , excel , studio , question , activities_panel	10	2801	August 3, 2022
Invoke Method to Clear Contents from Excel (not deleting rows) Help excel , uiautomation , activities	11	5596	October 29, 2018
Need to delete rows from excel Learn excel , activities	10	1020	February 25, 2020
How to clear content of starting from specific cell and keep the template Activities excel , question	1	263	August 1, 2023

Most Active Users - Yesterday
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil
More details...

Delete all content in an Excel Sheet

Related Topics