Tag Archives: Symbol

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: Answer:  Copy and Paste with a simple trick … What? Not Find and Replace?  Yes, you may do it by using … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 4 Comments

Insert “tick in a box” in Excel

Recently, I’ve been collecting Excel files from colleagues regarding implementation status of some activities in the region.  Part of the template looks like the screenshot below: Quite simple and straight forward, right? I expected I would get something like the following in … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 4 Comments

Input special characters in Excel by pressing Alt + Numpad

Perhaps you know that you can input some special characters/symbols by pressing Alt + Numpad together.  If you google “ALT Numpad”, you will probably find many extensive lists of special characters input in this way. Well, what to do with … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 2 Comments