Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I many times need to add additional numbers to the bottom of a column
of numbers that I'm summing. When I do this, I always have to reformat so the underline is at the new last number instead of at the original last number. Is there a way to "overline" the sum instead of underline the last number? I know that I can do this using borders, but I want to be able to actually use an underline with the accounting format. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Try this:
ToolsCustomizeCommands tab Category: Format Commands: (Find the Top Border icon) Drag that icon to another toolbar. Click the [Close] button The next time you need the top line...just click that button. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Buffgirl71" wrote: I many times need to add additional numbers to the bottom of a column of numbers that I'm summing. When I do this, I always have to reformat so the underline is at the new last number instead of at the original last number. Is there a way to "overline" the sum instead of underline the last number? I know that I can do this using borders, but I want to be able to actually use an underline with the accounting format. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
Change number format from text to number? | New Users to Excel | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) |