How to Apply Single Accounting Underline Format in Excel

In this article, we will learn to apply a single accounting underline format in Excel. Microsoft Excel users often need to use a single accounting underline format for different purposes. Today, we will use 4 methods. Using these methods, you will be able to apply a single accounting underline format easily in Excel. So, without any delay, let’s start the discussion.

Table of Contents hide

Download Practice Book

4 Quick Ways to Apply Single Accounting Underline Format in Excel

1. Get Single Accounting Underline from Format Cells Dialog Box

2. Apply Excel VBA to Insert Single Accounting Underline Format

3. Use Keyboard Shortcut to Get Single Accounting Underline Format in Excel

4. Insert Single Accounting Underline Format Using Excel Home Tab

Conclusion

Download Practice Book

You can download the practice book from here.

Apply Single Accounting Underline Format.xlsm

4 Quick Ways to Apply Single Accounting Underline Format in Excel

To explain these methods, we will use a dataset that contains information about the sales of the first three months of some sellers. We will apply single accounting underlines in the range C4:E4 and C9:E9. In the following sections, we will describe the methods in easy steps.

1. Get Single Accounting Underline from Format Cells Dialog Box

In Excel, we can get the single accounting underlines from the Format Cells dialog box. The steps of this method are easy and simple. Let’s follow the steps below to see how we can get single accounting underline from the format cells dialog box.

STEPS:

First of all, select the cells where you want to apply the single accounting underline format. Here, we have selected the ranges C4:E4 and C9:E9.

Secondly, right–click on a selected cell. A Context Menu will appear.
Select Format Cells from there. It will open the Format Cells dialog box.

In the Format Cells dialog box, click on the Font tab and then, select Single Accounting in the Underline field.
Click OK to proceed.

As a result, you will see the single account underlines in the desired ranges.

Finally, remove all the borders to see the single account underlines more clearly.

2. Apply Excel VBA to Insert Single Accounting Underline Format

We can also apply VBA to insert the single accounting underline format in Excel. For this purpose, we need to apply a single line of code in Excel. Here, we will use the same dataset. Let’s observe the steps below to see the application of VBA.

STEPS:

To begin with, go to the Developer tab and select Visual Basic. It will open the Visual Basic window.
Alternatively, you can press Alt + F11 to open the Visual Basic window.

Secondly, select Insert and then, select Module in the Visual Basic This will open the Module window.

In the Module window, type the code below:

Sub Single_Accounting_Underline()
Selection.Font.Underline = xlUnderlineStyleSingleAccounting
End Sub

In the following step, press Ctrl + S to save the code and close both the Module and Visual Basic window.
After that, select the ranges C4:E4 and C9:E9.

Again, navigate to the Developer tab and select Macros. It will open the Macro window.

In the Macro window, select the code and click on Run to run it.

After running the code, you will the single accounting underlines in the desired ranges.

In the end, you can remove all the borders to make the dataset clear.

3. Use Keyboard Shortcut to Get Single Accounting Underline Format in Excel

In the third method, we will use the keyboard shortcut to get the single accounting underline format in Excel. Here, we will use the keyboard shortcut to open the Format Cells dialog box and we will apply the single underline from there. Let’s follow the steps below to learn the method.

STEPS:

Firstly, select the ranges where you want to apply the single accounting underline format. Here, we have selected the ranges C4:E4 and C9:E9.

After that, press Ctrl + 1 to open the Format Cells dialog box.
In the Format Cells dialog box, click on the Font tab and then, select Single Accounting in the Underline field.
Click OK to move forward.

Instantly, you will have the single accounting underlines in the desired ranges.

Finally, you can remove the borders to make the dataset more understandable.

Note: To insert a single underline, select the ranges and press Alt, H, 3, and U one after another. It must be mentioned that there are a few basic differences between a single underline and a single accounting underline format.

4. Insert Single Accounting Underline Format Using Excel Home Tab

In the last method, we will insert the single accounting underline format using the excel Home tab. Here, we will use the same dataset. So, without any delay, let’s follow the steps below to learn the method.

STEPS:

In the first place, select the ranges C4:E4 and C9:E9.

Secondly, go to the Home tab and click on the Font Settings arrow icon. It will open the Format Cells window.

Thirdly, click on the Font tab in the Format Cells dialog box and select Single Accounting in the Underline field.
Click OK to proceed.

After that, you will see the single accounting underline format in the dataset.

Also, you can remove the borders to make them look understandable.

Alternatively, you can use a single underline instead of the single accounting underline format.
To do so, go to the Home tab and select Underline from the Font section.

It will have a similar kind of effect on the dataset.

Conclusion

In this article, we have discussed 4 easy methods to Apply Single Accounting Underline Format in Excel. I hope this article will help you to perform your tasks easily. Furthermore, we have also added the practice book at the beginning of the article. To test your skills, you can download it to exercise. You can also visit the ExcelDemy website for more articles like this. Last of all, if you have any suggestions or queries, feel free to ask in the comment section below.