The accounting underline will extend beyond the numbers. Choose Right (Indent), Left (Indent), or Distributed (Indent) from the Horizontal Alignment dropdown. To try it, go to Format Cells, Alignment. The big difference with the accounting underlines shows up when you use any of the (Indent) choices. The double underline extends almost to the edge of the cell. What is the difference between underlines and accounting underlines? For text, an accounting underline extends most of the way across the cell, while a regular underline includes only the characters in the cell.įor numbers, the single underline is under the characters. Add the double underline icon to the QAT. To create an underline without any text in Microsoft Word, press Ctrl+U to start the underline, then, press Ctrl+Shift+spacebar to create non-breaking spaces.Press and hold this keyboard shortcut combination to add multiple underlines next to each other, creating an underline.
Underline, Double Underline, and Underline Gallery. If you want one-click access to either the single or double underline, there are three Quick Access Toolbar icons. To apply a single underline, you then have to use the dropdown next to the Double Underline icon. Gotcha: When you choose Double Underline from the Home tab's Underline dropdown, the Underline icon changes to a Double Underline icon. On the Font tab, from the Underline dropdown you can select Single Accounting or Double Accounting. In the Borders gallery, click the border style that you want to apply. On the Home tab, click the arrow next to the Borders button.
The Home tab of the ribbon offers a single underline icon. He says I should double underline the grand total in a report. I have included one of the documents that is having this issue that you can troubleshoot, any help would be greatly appreciated. Manually recreating these documents by cutting and pasting into excel and back is not a reasonable solution, as I have hundreds of files affected by this issue. I have tried resizing the embedded sheet in word and converting it by "right-click > chart object > convert" but the double underline still does not show up when printed. The interesting thing is that when I copy the excel sheet out of Word and then paste it in a new blank Word or Excel document the lines show up just fine when printed. Unfortunately I do not know which version of Office the files were originally created with (either 03 or 07 in compatibility mode). I have also tried to print this document on different computers using different versions of Office (2002, 2003, and 2007).
How to apply double accounting underline in excel pdf#
This same problem happens when I print to other printers, even when I try printing to a virtual PDF printer.
These lines show up just fine in Word and in Print Preview. The problem is that when I print the Word document some double underlined text shows up as a single underline and some single lines do not show up at all. FIFO Inventory Valuation in Excel Step by Step. I have numerous Word documents that contain embedded excel sheets, and in these excel sheets there are certain cells that are set to use regular and double underline font. Add the double underline icon to the QAT.It has the dummy data that we can use to understand the process.
0 kommentar(er)
