We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

excel tick


sinbad1

Likes # 0

This is probably an easy one for those that use excel more than me.

I need to insert a tick or cross in the cells of my worksheet. I can copy and paste from the character map,however there must be an easier way of inserting a tick.

any ideas?

Like this post
howard60

Likes # 0

if you use alt I then s you get symbols once you find the one you want you can assign a hotkey to it. This will then install the symbol in the cell that is highlighted.

Like this post
howard60

Likes # 0

sorry that was in word you need character map in Excel
Insert ¢, £, ¥, ®, and other characters that are not on the keyboard
On the Windows Start menu, point to Programs, point to Accessories, and then click Character Map.
If Character Map is not available, see Windows Help for information about how to install a Windows component.

In the Font box, select the font that contains the character you want.


In the character grid, click the character you want.


Click Select, and then click Copy.
You can select and copy multiple characters.

Switch to your workbook, and then place the insertion point where you want to paste the character.


Click Paste .
If the character looks different from the one you selected, select the character and apply the same font you selected in Character Map.

Tip Character Map shows the key shortcut you can use in Microsoft Excel to insert the selected character. If the key shortcut includes a number key, press the key you want on the numeric keypad, not on the main keyboard area.

Like this post
Fellsider

Likes # 0

For a cross, I use Upper case X in Arial at 8pt
For a tick I use Webdings and lower case 'a'

Like this post
sinbad1

Likes # 0

howard60

alt I then s gives me the hyperlink not character map.struggling with getting the symbol when i enter and copy get different symbols.

the symbol does have some letters and a number6 how do i use this to insert character?

Fellsider i've looked in Webdings and 'a' does give a tick seems the easiest way for me
thanks

Like this post
Noldi

Likes # 0

If you hold down the Alt key type then a number in on the right hand number keys staerts 1 and goes into the 100s(not along the top) you get all sorts os symbols when you release the Alt key. I have a list at work of all sybols but not here I will post tomorrow but it would be better if you give it a go and see what happens.
Noldi

Like this post
sinbad1

Likes # 0

noldi

I have tried your alt/No thats great got different symbols, since there are 100s, chances of getting the tick number is a bit like the lottery.

Look forward to your next post, expect the list has lots of useful shortcuts to symbols.

The character map shows the symbol for a tick to be OxD6 ;but not been able to implement this into cell.

Thanks

Like this post
great1

Likes # 0

Put cursor in the cell you want to tick. Change to the Windings font. Hold down the Alt key and type 0252 on the numbers pad and press enter. A tick should appear in the active cell. It won't work if you try using the number keys running across the top of your keyboard. Only use the number pad to the right.

Like this post
TonyV

Likes # 0

Another way of getting a tick into the worksheet is to drag and drop it. If you open up the Character Map and select Wingdings, then select the Tick. If you now click the tick, then drag it to the Cell you want it in. Assuming your cell is formatted in Arial, the symbol will come up as u with 2 dots above it. Just change the font for that cell to Wingdings. You now have the tick!

Like this post
sinbad1

Likes # 0

Thanks for your response great1 and Tonyv both methods work, problem is there are different cells with crosses and ticks in different orders and would have to do them individually changing from wingdings to arial.

If noldi has a shortcut alt/No think this would be easier for me.

thanks

Like this post
Noldi

Likes # 0

I have looked in the symbol list out of 268 sybols no tick. If I had to use the tick I would write a macro as follows. This macro I set up to enter Ctrl+a. You can either copy this in to visual basics or record a macro yourself if you need to know how to do this let me know.
Noldi
PS I use Garmen version of Office so maybe somebody can change this to English but VB should unterstand this.


Sub tick()
'
' tick Makro
' Makro am 23/03/2005 von Chuter David aufgezeichnet
'
' Tastenkombination: Strg+a
'
With Selection.Font
.Name = "Webdings"
.Size = 10
End With
ActiveCell.FormulaR1C1 = "a"
End Sub

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

The best iPhone 6 alternatives: Price and specs compared with the best smartphones

IDG UK Sites

The top 10 Apple products ranked by pixel density: Which Apple devices have the sharpest screens?

IDG UK Sites

SBTRKT's Look Away webcam-based interactive music video won't keep your gaze

IDG UK Sites

Retina MacBook Air release date rumours and specs: Gold 12in Retina MacBook Air almost 1cm thinner...