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.


Download Practice Book

You can download the practice book from here.


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.

Get Single Accounting Underline from Format Cells Dialog Box

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

Get Single Accounting Underline from 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.

Get Single Accounting Underline from Format Cells Dialog Box

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

Get Single Accounting Underline from Format Cells Dialog Box

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

Get Single Accounting Underline from Format Cells Dialog Box

Read More: Apply the Accounting Number Format to the Selected Cells in Excel


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.

Apply Excel VBA to Insert Single Accounting Underline Format

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

Apply Excel VBA to Insert Single Accounting Underline Format

  • In the Module window, type the code below:
Sub Single_Accounting_Underline()
Selection.Font.Underline = xlUnderlineStyleSingleAccounting
End Sub

Apply Excel VBA to Insert Single Accounting Underline Format

  • 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.

Apply Excel VBA to Insert Single Accounting Underline Format

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

Apply Excel VBA to Insert Single Accounting Underline Format

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

Apply Excel VBA to Insert Single Accounting Underline Format

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

Apply Excel VBA to Insert Single Accounting Underline Format

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

Apply Excel VBA to Insert Single Accounting Underline Format

Read More: [Fixed] Accounting Format in Excel Not Working (2 Quick Solutions)


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.

Use Keyboard Shortcut to Get Single Accounting Underline Format in Excel

  • 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.

Use Keyboard Shortcut to Get Single Accounting Underline Format in Excel

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

Use Keyboard Shortcut to Get Single Accounting Underline Format in Excel

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

Use Keyboard Shortcut to Get Single Accounting Underline Format in Excel

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.

Read More: How to Apply Double Accounting Underline Format in Excel


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.


Related Articles

Mursalin

Mursalin

Hi there! This is Mursalin. I am an Excel and VBA content developer as well as an electrical and electronics engineer. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo