Go to Special + Copy and Paste do the magic

Answer to the 5 little Tips (tests) – Part 4/5

The task: To convert “1” to “Tick” in a table like the following one:

Excel Tips - Trick #4.png

Answer:  Copy and Paste with a simple trick …

What? Not Find and Replace?  Yes, you may do it by using Find and Replace.  As it is Excel, there are different ways to accomplish the same task.  Either way, the first thing we need to know is how to insert a “Tick” mark.  Sound silly? But are you sure every one knows how to do that??  I have a blogpost to describe how to perform a similar task.

The following screencast shows you how to accomplish the task:excel-tips-replace-1-with-tick

Here’s step-by-step instructions:

First insert “Tick” in an empty cell,

  1. Insert Tab –> Symbols
  2. Select “Windings” font
  3. Look for the “Tick” –> Insert –> Close

A “Tick” is inserted into the cell.

Then Copy and Paste,

  1. Copy the cell with “Tick”
  2. Select the range ( i.e. C4:D23 in the above example)
  3. HOME tab –> Editing group –> Find & Select –> Go to Special… (Shortcut tip: Ctrl+G, followed by Alt+S)
  4. Select “Constants” –> OK
  5. All the cells with “1” are selected.
  6. Paste (Tip: simply pressing Enter instead of Ctrl+V).

As simple as this.

You may wonder why I am not using the Find and Replace method.   Well,  I will leave that as your homework.  Try and observe.  Tell us your findings by leaving comments below.  🙂


Power BI Webinar


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , , . Bookmark the permalink.

4 Responses to Go to Special + Copy and Paste do the magic

  1. That was very useful and extremely well done. Thank you for spending the time to to it.


  2. Sabine says:

    Hello MF,
    I’ve used the Find and Replace method. And it’s very simple.

    Select the range
    Change the font into Wingdings
    Ctrl + H: Find 1 and replace it with ü

    That’s all you have to do.



Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.