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

Advertisements
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.

    Like

  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.

    Sabine

    Like

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s