How to Apply Single Accounting Underline Format in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Apply Single Accounting Underline Format in Excel: 4 Easy Ways

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 a single accounting underline from the format cells dialog box.

STEPS:

  • First, 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, right–click 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 underlined in the desired ranges.

Get Single Accounting Underline from Format Cells Dialog Box

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

Get Single Accounting Underline from Format Cells Dialog Box

Read More: What Is Accounting Number Format in Excel


2. Apply Excel VBA to Insert Single Accounting Underline Format

We can also apply VBA to insert the single accounting underlined 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


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


4. Insert Single Accounting Underline Format Using Excel Home Tab

In the last method, we will insert the single accounting underlined 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 underlined 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.

Read More: How to Center Accounting Format in Excel


Download Practice Workbook


Conclusion

In this article, we have discussed 4 easy methods to apply a 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. Last of all, if you have any suggestions or queries, feel free to ask in the comment section below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , and premium Excel consultancy services for Excel and business users. Feel free to contact us with your Excel projects.
Mursalin Ibne Salehin
Mursalin Ibne Salehin

Hi there! This is Mursalin. I am currently working as a Team Leader at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I manage and help the writers to develop quality content in Excel and VBA-related topics.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo