Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Buffgirl71
 
Posts: n/a
Default Overline the sum instead of underline the number

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default Overline the sum instead of underline the number

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excell-How to add the number of cells containing text? = a sum aruba64taw Excel Worksheet Functions 2 December 21st 05 09:51 AM
Generating (in a random order)each number once from a given number Neil Goldwasser Excel Worksheet Functions 2 December 2nd 05 11:27 PM
Change number format from text to number? Scot New Users to Excel 2 December 1st 05 04:15 PM
vlookup with more than number to be retrieved martelie Excel Worksheet Functions 3 October 14th 05 12:50 PM
Count Number of Characters in a cell? AHJuncti Excel Discussion (Misc queries) 2 June 16th 05 07:39 PM


All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"