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.
- 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 underlined in the desired ranges.
- Finally, remove all the borders to see the single account underlined more clearly.
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.
- 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 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.
- 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 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
- How to Make Negative Accounting Numbers Red in Excel
- [Fixed] Accounting Format in Excel Not Working
- How to Apply Accounting Number Format in Excel
- How to Apply Double Accounting Underline Format in Excel
- How to Change Accounting Format in Excel
- How to Convert Accounting Format to Number Format in Excel
- How to Apply the Accounting Number Format to the Selected Cells in Excel
- How to Simultaneously Apply Accounting Number Format in Excel