#ACCOUNTING UNDERLINE IN EXCEL HOW TO#

Note that you can select an entire row by clicking the row number at the left of the sheet, or you can select an entire column by clicking the column letter. Step 2: Select the cell(s) to which you want to apply the double underline formatting. Step 1: Open the spreadsheet containing the value(s) that you wish to double underline. The steps in this article were performed in Excel 2013, but will work in Excel 2010 or 2016 as well.

#ACCOUNTING UNDERLINE IN EXCEL HOW TO#

How to Double Underline a Value (Numbers or Letters) in Excel 2013 Even if accountants have some other accounting software at their disposal they always like to involve excel. Around the world excel is the most active computer application in the hands of accountants. If editing in a cell is turned on, you can select the cell contents by double-clicking the cell.

To underline just a portion of the contents in a cell, double-click that cell, and then select the text or numbers that you want to underline. If you are working with a colleague or client that requires certain fields to have double underlines, then you can follow this guide. View ContentsExcel and accountants are two interconnected entities. To underline all text or numbers in a cell or range of cells, select that cell or range of cells. Our guide below will show you how to select a cell or group of cells, then apply formatting that will apply a double underline to the data in those cells. But there are actually several different underline options in Excel 2013, including a Double Underline option. One of the formatting options that I see very little of is underlining other than the standard single-underlining option in Excel. There are many different types of formatting that you can apply to the numbers or words in your Excel spreadsheet, and even very experienced Excel users are unlikely to encounter, much less use, all of these options. Working with data is often more than simply using the right formula to perform your calculations. Its been a while you got any update on Excel but I hope this much awaited template plus complete how to series will follow in next few weeks explaining every bit that how its done from scratch will.

Accounting underline in excel