Clearing cell ranges

Overview

The clear cell range instruction allows a user to clear the contents and/or the formatting from a cell or a range of cells within a particular Excel worksheet.

Before we get started

For the purposes of this article, it would be preferable if you can have at hand a Excel file containing data and formatting. Please also create a data step with a ‘File upload/download’ property and upload the file into the property. Please further create a ‘Manipulate a file’ or ‘Multiple file manipulations’ action step so that you can add and use instructions. The file that this article will refer to looks like this:

Steps

1. Create a ‘Clear cell range’ instruction.

2. Link the file.

3. Select a worksheet. Here, we will select Sheet1.

4. Use any cell you wish. Here, we will use an Advanced Range from cell A1 to cell C3.

5. Tick the box next to ‘Clear cell format?’.

6. Save and run the step.

7. If you open the file after the step finishes running, you will see that the cell range specified above is devoid of contents and formatting.

Leave a Reply

Latest Tweets

Free eBook: 10 Tips for sourcing good data yucalc.com/2017/02/17/fre…

reply · retweet · favorite

Newsletter

By signing up, you agree to our Terms of Service and Privacy Policy.

Address

Suite 1506, Westfield Tower 2, 101 Grafton St Bondi Junction NSW 2022 Australia

View Larger Map

Contact Us

AUS: +61-2-9386-0202
UK: +44-20-8123-1251
Send us an email

ContactUs.com
WordPress Image Lightbox