Wikipedia:Reference desk/Archives/Computing/2021 June 19
Computing desk | ||
---|---|---|
< June 18 | << May | June | Jul >> | June 20 > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
June 19[edit]
How do you get a check mark symbol to appear in an Excel file / spreadsheet?[edit]
How do you get a check mark to appear in an Excel file / spreadsheet? What exactly do I have to type in, into the empty cell? I tried using "insert symbols" ... (from Microsoft WORD) ... but they only have a "radical symbol" (and not a "check mark" symbol), as far as I can tell. If it matters, I prefer the fifth one down on this list:
The "Symbol, Other" category of Unicode provides various check marks:
- U+237B ⍻ NOT CHECK MARK
- U+2611 ☑ BALLOT BOX WITH CHECK
- U+2705 ✅ WHITE HEAVY CHECK MARK
- U+2713 ✓ CHECK MARK
- U+2714 ✔ HEAVY CHECK MARK
- U+1F5F8 🗸 LIGHT CHECK MARK
- U+1F5F9 🗹 BALLOT BOX WITH BOLD CHECK
The pre-provided radical symbol in the Microsoft WORD (not Excel) drop-down selection for "Insert Symbols" looks like this symbol here:
- √ || U+221A ||
√
or√
||%E2%88%9A
||√
Thanks. Joseph A. Spadaro (talk) 21:18, 19 June 2021 (UTC)
- Joseph A. Spadaro, are you in Windows, Mac OS...? Elizium23 (talk) 00:39, 20 June 2021 (UTC)
- Elizium23 - Thanks. I use Windows 10 and Microsoft 365 Office. Thanks. Joseph A. Spadaro (talk) 01:47, 20 June 2021 (UTC)
- Joseph A. Spadaro, Microsoft Support: Insert ASCII or Unicode Latin-based symbols and characters Elizium23 (talk) 01:57, 20 June 2021 (UTC)
- Elizium23 - Thanks. I use Windows 10 and Microsoft 365 Office. Thanks. Joseph A. Spadaro (talk) 01:47, 20 June 2021 (UTC)
- You could also try to copy-and-paste a checkmark into a spreadsheet. It works for me. ←Baseball Bugs What's up, Doc? carrots→ 03:04, 20 June 2021 (UTC)
- Also described explicitly on the Microsoft Support pages.--Phil Holmes (talk) 09:10, 20 June 2021 (UTC)
Thanks, all. I finally did find an "insert symbol" drop-down list in Excel, like they have in Word. There are a million ridiculous symbols to scroll through ... which I am sure are rarely / never used. And you have to select "Wing Dings" as a font to ultimately find the check-mark. I guess that I was assuming ... check-marks being such a common symbol ... that the Excel people would make the check-mark symbol easier to find and to insert. Not knowing any of this -- prior to today -- I have been using the "square root / radical" symbol as the "next best thing" ... for some 20-25 odd years now. Thanks Joseph A. Spadaro (talk) 15:50, 20 June 2021 (UTC)
- It would be nice if Insert > Symbol was easy to find in Excel (and PowerPoint too), but remember this is the company that gave us ribbons... 93.136.85.186 (talk) 23:29, 20 June 2021 (UTC)
- Yeah, exactly. Joseph A. Spadaro (talk) 03:17, 21 June 2021 (UTC)
- Yes, but one has to know the code first. I guess I am saying that ... amidst the thousands of (extremely) useless symbols in there ... the Excel programmers could have made the very common check-mark symbol much easier to find. Thanks. Joseph A. Spadaro (talk) 18:15, 21 June 2021 (UTC)
- You could construct your own Excel file with your favorite symbols embedded in, which you can copy-and-paste anytime you need one. A little tedious, perhaps, but more likely to be satisfactory than badgering Microsoft! ←Baseball Bugs What's up, Doc? carrots→ 22:15, 21 June 2021 (UTC)
- Yes, but one has to know the code first. I guess I am saying that ... amidst the thousands of (extremely) useless symbols in there ... the Excel programmers could have made the very common check-mark symbol much easier to find. Thanks. Joseph A. Spadaro (talk) 18:15, 21 June 2021 (UTC)
- Thanks. Generally speaking, I don't really ever need any special symbols. Or, if / when I do, they are very easy to find. I am (still) surprised at how much they "hid" such a common symbol as the check-mark. I mean, who would think to look under "Wing Dings" for that? It should probably be one of the first 4 or 5 symbols that pops up right away. And, I can hardly believe that I have been using the "square root" symbol for the past 20-25 years, thinking that there was no check-mark symbol available at all. As far as badgering Microsoft, I assume that would be a fool's errand. I can barely get help from them, when I really need it. Joseph A. Spadaro (talk) 03:35, 22 June 2021 (UTC)