How To Create A Check Register In Excel Mac

Scout video – Insert and Utilise Checkmark Symbol in Excel

Beneath is the written tutorial, in example you prefer reading over watching the video.

In Excel, there are two kinds of tick marks (✓) that you tin can insert – a check mark and a checkbox.

And no… these are not the same.

Let me explain.

Bank check Mark Vs Check Box
Inserting Check Mark Symbol in Excel
- Copy and Paste the Check Mark
- Use the Keyboard Shortcuts
- Using the Symbols Dialog Box
- Using the CHAR Formula
- Using Autocorrect
- Using Conditional Formatting to Insert Check Mark
- Using a Double-Click (uses VBA)
Formatting the Check Mark Symbol
Format Bank check Mark / Cross Marking Using Provisional Formatting
Count Bank check Marks

Check Marker Vs Check Box

While a check mark and a checkbox may expect somewhat similar, these two are very different in the way it tin be inserted and used in Excel.

A cheque marker is a symbol that yous tin can insert in a cell (only similar any text that you lot type). This means that when y'all copy the prison cell, you also re-create the check mark and when you delete the cell, yous besides delete the bank check mark. Merely like regular text, you can format it by changing the color and font size.

A checkbox, on the other hand, is an object that sits in a higher place the worksheet. And then when you place a checkbox above a cell, information technology'due south not a function of the cell simply is an object that is over information technology. This ways that if you delete the cell, the checkbox may not get deleted. As well, you can select a checkbox and drag information technology anywhere in the worksheet (every bit information technology's not bound to the prison cell).

You will observe checkboxes being used in interactive reports and dashboards, while a checkmark is a symbol that you may want to include equally a role of the report.

A check mark is a symbol in the jail cell and a checkbox (which is literally in a box) is an object that is placed above the cells.

In this commodity, I volition only exist roofing cheque marks. If you want to learn more virtually checkbox, here is a detailed tutorial.

There are quite a few ways that you lot can use to insert a check marker symbol in Excel.

Click here to download the example file and follow along

Inserting Check Mark Symbol in Excel

In this article, I volition show y'all all the methods I know.

The method you use would exist dependent on how you desire to use the cheque mark in your work (as you lot'll see later in this tutorial).

Let'due south get started!

Copy and Paste the Check Mark

Starting with the easiest ane.

Since you lot're already reading this article, you can copy the below bank check marker and paste it in Excel.

To exercise this, re-create the check marking and become to the prison cell where you want to copy it. At present either double-click on the cell or press the F2 key. This will take you to the edit mode.

✔

Simply paste the check mark (Control + V).

Once you have the check mark in Excel, yous can copy information technology and paste information technology every bit many times equally you want.

This method is suited when yous want to copy paste the check mark in a few places. Since this involves doing information technology manually, it's not meant for huge reports where y'all take to insert check marks for hundreds or thousands of cells based on criteria. In such a instance, it's better to use a formula (as shown later in this tutorial).

Use the Keyboard Shortcuts

For using the keyboard shortcuts, you volition have to change the font of the cells to Wingdings 2 (or Wingdings based on the keyboard shortcut you lot're using).

Below are the shortcuts for inserting a check mark or a cross symbol in cells. To use the below shortcuts, you need to alter the font to Wingdings 2.

Below are some more than keyboard shortcuts that you can use to insert check mark and cross symbols. To use the below shortcuts, you lot need to change the font to Wingdings (without the 2).

This method is best suited when you lot only desire a check mark in the cell. Since this method requires you to change the font to Wingdings or Wingdings two, information technology will not be useful if y'all desire to have any other text or numbers in the same cell with the check marker or the cross mark.

Using the Symbols Dialog Box

Another style to insert a check marker symbol (or any symbol for that thing) in Excel is using the Symbol dialog box.

Here are the steps to insert the check mark (tick marker) using the Symbol dialog box:

Select the cell in which you want the check mark symbol.
Click the Insert tab in the ribbon.
Click on the Symbol icon.
In the Symbol dialog box that opens, select 'Segoe UI Symbol' as the font.
Coil down till you find the bank check marking symbol and the double click on it (or click on Insert).

The in a higher place steps would insert one check mark in the selected prison cell.

If you want more, just re-create the already inserted one and use information technology.

Annotation that using 'Segoe UI Symbol' allows you to utilise the check mark in whatsoever regularly used font in Excel (such as Arial, Time At present, Calibri, or Verdana). The shape and size may adjust a footling based on the font. This also ways that you can have text/number forth with the check marker in the aforementioned cell.

This method is a fleck longer simply doesn't require you to know any shortcut or CHAR code. Once you have used it to insert the symbol, y'all can reuse that one past copy pasting it.

Using the CHAR Formula

Yous tin can utilize the CHAR part to return a bank check mark (or a cantankerous mark).

The below formula would render a bank check marking symbol in the prison cell.

=CHAR(252)

For this to work, you demand to catechumen the font to Wingdings

Why?

Because when you use the CHAR(252) formula, it would requite y'all the ANSI character (ü), and then when you lot change the font to Wingdings, it is converted to a check mark.

You tin can apply similar CHAR formulas (with dissimilar code number) to become another format of the check mark or the cross marking.

The existent benefit of using a formula is when you utilise information technology with other formulas and return the check marker or the cantankerous marking as the result.

For example, suppose yous take a dataset as shown below:

You tin use the beneath IF formula to become a check marker if the sale value is more than 5000 and a cross marking if information technology's less than 5000.

=IF(A2>5000,CHAR(252),CHAR(251))

Remember, yous need to convert the column font to Wingdings.

This helps yous make your reports a lilliputian more visual. Information technology too works well with printed reports.

If you want to remove the formula and merely keep the values, copy the cell and paste it as value (right-click and cull the Paste Special and then click on Paste and Values icon).

This method is suited when y'all want the cheque mark insertion to exist dependent on cell values. Since this uses a formula, y'all can use it fifty-fifty when you have hundreds or thousands of cells. Also, since you need to modify the font of the cells to Wingdings, you lot can't have anything else in the cells except the symbols.

Using Autocorrect

Excel has a feature where it can autocorrect misspelled words automatically.

For example, type the word 'bcak' in a cell in Excel and see what happens. It will automatically correct it to the word 'back'.

This happens every bit there is already a pre-fabricated list of expected misspelled words you're likely to blazon and Excel automatically corrects it for yous.

Here are the steps to use autocorrect to insert the delta symbol:

Click on the File tab.
Click on Options.
In the Options dialogue box, select Proofing.
Click on the 'AutoCorrect Options' push button.
In the Autocorrect dialogue box, enter the following:
- Replace: CMARK
- With: ✔ (y'all can copy and paste this)
Click Add together so OK.

Now whenever yous type the words CMARK in a cell in Excel, it will automatically change it to a cheque mark.

Here are a few things you need to know when using the Autocorrect method:

This is case sensitive. And then if you enter 'cmark', information technology volition not get converted into the check mark symbol. You lot demand to enterCMARK.
This alter too gets applied to all the other Microsoft applications (MS Word, PowerPoint, etc.). So be cautious and choose the keyword that you are highly unlikely to use in any other application.
If at that place is whatsoever text/number earlier/afterwards CMARK, it will non be converted to the check mark symbol. For example, '38%CMARK' will not get converted, however, '38% CMARK' volition get converted to '38% ✔'

Using Provisional Formatting to Insert Check Marker

You can use conditional formatting to insert a check marker or a cross mark based on the cell value.

For case, suppose y'all have the data fix every bit shown below and you want to insert a cheque mark if the value is more than than 5000 and a cantankerous mark if it's less than 5000.

Here are the steps to do this using conditional formatting:

In jail cell B2, enter =A2, and and so re-create this formula for all cells. This will make certain that now you have the same value in the adjacent cell and if you change the value in column A, it'southward automatically changed in column B.
Select all the cells in column B (in which yous want to insert the cheque mark).
Click the Home tab.
Click on Conditional Formatting.
Click on New Dominion.
In the 'New Formatting Rule' dialog box, click on the 'Format Style' drop downwards and click on 'Icon Sets'.
In the 'Icon Style' drop-down, select the style with the check mark and cross mark.
Cheque the 'Show Icon only' box. This will ensure that merely the icons are visible and the numbers are hidden.
In the Icon settings. alter the 'per centum' to the 'number' and make the settings as shown beneath.
Click OK.

The in a higher place steps will insert a green bank check mark whenever the value is more than than or equal to 5000 and a crimson cross mark whenever the value is less than 5000.

In this case, I have but used these two icons, simply you can likewise utilise the yellow exclamation mark besides if you want.

Using a Double-Click (uses VBA)

With a footling bit of VBA lawmaking, you can create an awesome functionality – where it inserts a check marker as soon as yous double click on a jail cell, and removes information technology if yous double click once again.

Something as shown below (the red ripple indicates a double click):

To practise this, yous need to use the VBA double-click event and a simple VBA lawmaking.

But earlier I give yous the full code to enable double click, let me quickly explain what how VBA tin can insert a check mark. The below code would insert a cheque mark in cell A1 and change the font to Wingdings to make certain y'all see the check symbol.

Sub InsertCheckMark() Range("A1").Font.Proper name = "Wingdings" Range("A1").Value = "ü" Finish Sub

Now I volition use the same concept to insert a cheque mark on double click.

Below is the code to do this:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel Equally Boolean) If Target.Column = 2 Then Cancel = True Target.Font.Name = "Wingdings"     If Target.Value = "" And so         Target.Value = "ü"     Else         Target.Value = ""     End If Stop If End Sub

Yous demand to copy and paste this code in the code window of the worksheet in which you need this functionality. To open up the worksheet code window, left-click on the sheet name in the tabs and click on 'View Lawmaking'

This is a good method when you need to manually scan a list and insert check marks. Y'all can hands do this with a double click. The best apply case of this is when you're going through a list of tasks and take to mark it as done or non.

Click here to download the instance file and follow along

Formatting the Cheque Mark Symbol

A check mark is but like any other text or symbol that you lot utilize.

This ways that you can easily alter its color and size.

All you need to exercise is select the cells that have the symbol and apply the formatting such as font size, font color, and bold etc.

This way of formatting symbols is manual and suited only when yous have a couple of symbols to format. If yous have a lot of these, information technology's better to use provisional formatting to format these (equally shown in the next section).

Format Cheque Marking / Cross Mark Using Provisional Formatting

With provisional formatting, you tin can format the cells based on what type of symbol it has.

Beneath is an example:

Column B uses the CHAR function to render a check mark if the value is more than 5000 and a cross mark if the value is less than 5000.

The ones in column C and D uses conditional formatting and wait way better as it improves visual representation using colors.

Let'due south see how you can do this.

Below is a dataset where I have used the CHAR function to get the bank check mark or cross marker based on the cell value.

Below are the steps to color the cells based on the symbol it has:

Select the cells that take the check-marking/cantankerous-mark symbols.
Click the Home tab.
Click on Provisional Formatting.
Click on 'New Rule'.
In the New Formatting Dominion dialog box, select 'Apply a formula to determine which cells to format'
In the formula field, enter the following formula: =B2=CHAR(252)
Click the Format button.
In the 'Format Cells' dialog box, go to the Fill tab and select the green color.
Get to the Font tab and select colour as white (this is to make sure your checkmark looks nice when the cell has a green groundwork color).
Click OK.

After the above steps, the data is going to look as shown below. All the cells that have the check marker will be colored in green with white font.

You need to repeat the same steps to now format the cells with a cross mark. Modify the formula to =B2=char(251) in step vi and formatting in step 9.

Count Check Marks

If y'all want to count the total number of check marks (or cross marks), you tin exercise that using a combination of COUNTIF and CHAR.

For instance, suppose you have the information set as shown beneath and you want to notice out the total number of stores that have achieved the sales target.

Below is the formula that will give y'all the full number of cheque marks in column C

=COUNTIF($C$2:$C$ten,CHAR(252))

Note that this formula relies on y'all using the ANSI code 252 to get the check marker. This would work if you have used the keyboard shortcut ALT 0252, or have used the formula =Char(252) or have copied and pasted the check marker that is the created using these methods. If this is not the case, then the higher up COUNTIF office is not going to work.

You May Also similar the following Excel tutorials: