Latest Lists

How can I insert special characters, such as a check mark in a cell in Excel using my keyboard only?

I want to put check marks in entries I made into my Excel 2007 worksheet after a transaction is completed like a check-off list. I don't want to keep going to the insert symbol tabs to do this. How can I insert the check mark using my keyboard?

Public Comments

1. you cant just use your keyboard. if you cant find t in excel then go to your menu the go to all programs then go to Accessories then click system tools then character map find your characters their
2. First, insert the check mark into a cell and then copy it (copy only the check mark text, not the whole cell). Click the Office Button, go to Excel Options, click Proofing, click the "Auto Correct Options" button. In the "Replace" field, enter something you don't usually type, such as ^^ or @@. Then click in the "With" field and press CTRL+V to paste the check mark. Click "Add", then OK. Now whenever you press ^^ it will change to a check mark. Be sure to select the text and click Copy--don't just select the cell and copy.
3. • Select the Range where you wish to insert the check marks • Change the FONT to "Wingdings" • Select the cell & hold the ALT Key+129 ÕÕ C ~
4. The best way is to format a cell or column to use Excel's own check mark graphic, added in this version via Icon Sets: - Select range where you want check marks (or also crosses) - Apply Conditional Formatting > Icon Sets > green check, yellow bang, red cross - Go to Conditional Formatting > Manage Rules > Edit Rule - Change the display rules: - - Check: >= 1 (number) - - Bang: > 0 (number) By default, no symbol appears for blank cells. If you enter 1, you will get a check mark. Enter a decimal (such as .5), and you will get an exclamation point (bang). Enter a zero, and you will get a cross. You can also change the CF formatting to "Show Icon Only". This way, you can still use the cell values in certain calculations: B1 = [ 0 for FALSE, 1 for TRUE; shows cross or check mark ] C1 = IF(B1, "Good Job!", "BACK TO WORK!!1")
5. How about just using your mouse and a 'double click' to insert a check mark into any cell in the workbook? Copy the following event handler to the clipboard: Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, _ ByVal Target As Range, Cancel As Boolean) ActiveCell.Font.Name = "wingdings 2" ActiveCell.Font.Size = 12 ActiveCell.Font.Bold = True ActiveCell.Value = "P" ActiveCell.HorizontalAlignment = xlCenter End Sub Press ALT + F11 Double click 'THIS WORKBOOK' in the Microsoft Excel Objects in the upper left quadrant. Paste the event handler into the workbook module editing area to the right. Close the VBE, return to the worksheet. and save the workbook. Double click any cell and a check mark will be inserted.