您可能希望在Excel(Excel)中使用复选标记的原因有很多。在某些情况下,您可能只想将复选标记图像放置在具有其他文本的单元格中或单独放置在单元格中。
在Excel(Excel)中使用复选标记的更具交互性的方式可能是接受用户的选择输入,或者作为一种自动方式来指示已完成的任务或行是否为真。
无论您打算如何使用它,都可以通过多种方式将复选标记集成到Excel电子表格中。
复选标记的键盘快捷键
如果您只需要在单元格中插入复选标记,无论是作为现有文本的一部分还是作为其本身,使用键盘快捷键是在(using keyboard shortcuts)Excel中使用复选标记的最简单方法。
有两个Wingdings2字符非常适合在(Wingdings2)Excel中插入复选标记。要使用这些,您需要右键单击单元格并将字体样式更改(change the font style)为Wingdings2。
格式化单元格后,只需按住Shift键并按 P。此处的键盘快捷键是Shift + P。
这将在单元格中插入一个复选标记字符。您也可以将其插入单元格中任何文本行的末尾。
另一个字符是复选标记的反面,一个“x”,您可以在其中表示否定响应。按住Shift键并按 O。此处的键盘快捷键是Shift + O。
这将在单元格中插入一个“x”字符。
对于需要添加肯定或否定答案的快速列表,这两个Excel复选标记可以解决问题。
其他Wingdings2 键盘(Wingdings2 keyboard)代码包括以下内容。
- Shift + R : 勾选框
- Shift + Q , Shift + S , Shift + T : 方框内各种样式的“x”
- Shift + V, Shift + U : 圆圈内各种样式的“x”
如果您需要更多种类,请改用Wingdings字体格式化单元格。
这使您可以使用四个潜在的复选标记键盘快捷键。
- ALT 0252:标准复选标记
- ALT 0254:框内的复选标记
- ALT 0251 : 标准“x”标记
- ALT 0253:“x”在一个盒子里
要使用这些键盘代码,请按住ALT键,然后使用(ALT)数字键盘(numeric pad)键入四位数字。
如您所见,有很多选项和样式可用于在Excel中使用复选标记。
更喜欢(Prefer)使用CHAR函数?不是问题。只需(Just)选择要放置符号的单元格并键入以下功能之一。
- =CHAR(252) : 标准复选标记
- =CHAR(254) : 方框内的复选标记
- =CHAR(251) : 标准“x”标记
- =CHAR(253) : 方框内的“x”
按Enter,复选标记将出现在该单元格中。
插入复选标记符号
您可以使用Segoe UI Symbol字体插入几个复选标记符号。为此,请从菜单中选择插入,然后从功能区中选择(Insert)符号(Symbols)图标。然后,从下拉列表中选择符号。(Symbol)
这将打开符号(Symbol)窗口。将字体(Font)下拉菜单更改为Segoe UI Symbol。
如果您滚动浏览此字体的符号列表,您会看到散布在各处的几种复选标记样式。一个部分在一个区域中同时具有复选标记和“x”样式标记。
但是,如果您想使用不同的样式,请随意滚动。
当您找到所需的复选标记时,只需选择插入(Insert),该符号将直接插入到您放置光标的Excel单元格中。(Excel)
如果您不记得任何代码并希望从更多种类的样式中浏览,这是在Excel中使用复选标记的一种简单方法。
将复选标记粘贴到 Excel 中
如果您不想要代码或字体的麻烦,在Excel中使用复选标记的一种快速简便的方法是复制和粘贴它(copy and paste it)。
如果您在Google(Google)中搜索“复选标记” ,您会在搜索结果中(in search results)首先看到一个复选标记符号。
您可以通过突出显示该符号并按Ctrl + C在结果中直接复制该符号。然后,返回您的Excel电子表格,选择要放置复选标记的单元格,然后按Ctrl + V将其粘贴。
使用复选标记(Check Mark)自动更正关键字(Keyword)
您可以忘记上面解释的所有符号或菜单,只需在要放置复选标记的任何地方使用您自己的特殊短语。
例如,您可以在Excel中创建自己的自动更正响应,用复选标记符号替换您的关键字(例如“CMARK”)。
为此,请使用上述任何一种方法在工作表中打勾。一旦工作表中只有一个,您就可以将其用作自动更正的一部分。
1.选择单元格并复制公式栏中的复选标记。
2. 右键单击单元格并检查单元格的字体。请注意这一点以备后用。
3. 选择文件(File),然后是选项(Options),然后是校对(Proofing),最后是自动更正选项(AutoCorrect Options)。
4. 在自动更正窗口中,在(AutoCorrect)替换(Replace)字段中输入单词(如“CMARK”) 。然后,选择With字段并按Ctrl + VExcel公式栏中复制的复选标记符号。
选择添加(Add),然后确定(OK)完成。
现在,每当您键入“CMARK”并按Enter时,文本将自动变为复选标记。
这是在Excel中使用复选标记的最简单方法之一,尤其是当您经常使用它们并且不想记住键盘快捷键、代码或其他任何内容时。
为什么在 Excel 中使用复选标记?
您可能想在 Excel 中使用复选标记的原因有很多。无论您是尝试跟踪项目任务还是让人们为您填写调查表,都有很多选择。
选择对您来说最方便的向电子表格添加复选标记的方法。
4 Ways to Use a Check Mark in Excel
There are many reasons you maу want to usе a check mark in Excel. In sоme cases, you may јust want a way to place a check mark image either in a cell wіth other text or in a сell by itѕelf.
More interactive ways to use check marks in Excel may be to accept selection input from a user or as an automatic way to indicate that a completed task or a row is true.
Regardless of how you intend to use it, there are ways you can integrate check marks into your Excel spreadsheet.
Keyboard Shortcuts for Check Marks
If all you need is to insert a checkmark into a cell, either as part of an existing text or by itself, using keyboard shortcuts is the easiest way to use a check mark in Excel.
There are two Wingdings2 characters that work well for inserting check marks into Excel. To use these, you’ll need to right-click the cell and change the font style to Wingdings2.
Once the cell is formatted, just hold down the Shift key and press P. The keyboard shortcut here is Shift + P.
This will insert a checkmark character into the cell. You can also insert this at the end of any line of text in the cell as well.
Another character is the opposite of a check mark, an “x” where you can symbolize a negative response. Hold down the Shift key and press O. The keyboard shortcut here is Shift + O.
This will insert an “x” character into the cell.
For a quick list where you need to add a positive or negative answer, these two Excel check marks do the trick.
Other Wingdings2 keyboard codes include the following.
- Shift + R: Check mark in a box
- Shift + Q, Shift + S, Shift + T: Various styles of “x” inside a box
- Shift + V, Shift + U: Various styles of “x” inside a circle
If you need more variety, then format the cells in the Wingdings font instead.
This lets you use four potential check mark keyboard shortcuts.
- ALT 0252: Standard check mark
- ALT 0254: Check mark inside a box
- ALT 0251: Standard “x” mark
- ALT 0253: “x” inside a box
To use these keyboard codes, hold down the ALT key and then type the four digit number using the numeric pad.
As you can see there are plenty of options and styles to use for using check marks in Excel.
Prefer using the CHAR function instead? Not a problem. Just choose the cell where you’d like to place the symbol and type one of the following functions.
- =CHAR(252): Standard check mark
- =CHAR(254): Check mark inside a box
- =CHAR(251): Standard “x” mark
- =CHAR(253): “x” inside a box
Press Enter and the check mark will appear in that cell.
Insert Check Mark Symbols
There are several check mark symbols you can insert using the Segoe UI Symbol font. To do this, select Insert from the menu and choose the Symbols icon from the ribbon. Then, select Symbol from the dropdown.
This will open the Symbol window. Change the Font dropdown to Segoe UI Symbol.
If you scroll through the list of symbols for this font, you’ll see several check mark styles scattered throughout. One section has both check marks and the “x” style marks in one area.
However, feel free to scroll if you want to use a different style.
When you find the check mark you want, just select Insert and that symbol will be inserted directly into the Excel cell where you placed the cursor.
This is an easy way to use a check mark in Excel if you can’t remember any of the codes and would like to browse from a larger variety of styles.
Paste a Check Mark into Excel
If you don’t want the hassle of codes or fonts, a quick and easy way to use a check mark in Excel is to copy and paste it.
If you search for “check mark” in Google, you’ll see a check mark symbol listed first in search results.
You can copy this symbol right in the results by highlighting it and pressing Ctrl + C. Then, return to your Excel spreadsheet, select the cell where you want to place the check mark, and paste it by pressing Ctrl + V.
Autocorrect a Keyword with a Check Mark
You could forget about all of the symbols or menus explained above and just use your own special phrase wherever you want to place a checkmark.
For example, you can create your own autocorrect response in Excel that replaces your keyword (something like “CMARK”) with the check mark symbol.
To do this, place a checkmark in your sheet using any one of the methods above. Once you have just one in the sheet, you can use it as part of an autocorrect.
1. Select the cell and copy the check mark in the formula bar.
2. Right-click the cell and check the font of the cell. Note this for later.
3. Select File, then Options, then Proofing, and finally AutoCorrect Options.
4. In the AutoCorrect window, enter the word (like “CMARK”) into the Replace field. Then, select the With field and press Ctrl + V to paste the check mark symbol you copied from the Excel formula bar earlier.
Select Add and then OK to finish.
Now, whenever you type “CMARK” and press Enter, the text will automatically change to a check mark.
This is one of the easiest ways to use a check mark in Excel, especially if you use them often and don’t want to remember keyboard shortcuts, codes, or anything else.
Why Use Check Marks in Excel?
There are plenty of reasons why you may want to use check marks in excel. Whether you are trying to track project tasks or getting people to fill out a survey for you—there are plenty of options.
Choose the method for adding check marks to your spreadsheet that’s the most convenient for you.