Adding comments to cells

Overview

The Add comment to cell instruction allows users to add a desired comment to a cell or a range of cells within a particular Excel worksheet. Once the instruction is run, the comment will appear in a small window when the cursor hovers over the specified cell or range of cells.

Before we get started

For the purposes of this article, it would be preferable if you can have a blank Excel file handy. 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.

Steps

1. Create an ‘Add comment to cell’ instruction.

2. Link the file.

3. Select a worksheet.

4. Use any cell you wish. Here, we will use cell B3.

5. Type a comment.

6. Run the step.

7. Open the file after the step has finished running. If you hover your cursor over the cell you selected, you will see that the comment you specified appear.

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