border line for total

[Chris Dowling <do...@gmail.com>]

Hi


How do I put a line under a number to indicate it is a total or subtotal?

Thanks and regards

Chris






Sent from Windows Mail

Re: border line for total

[Brian Barker <b....@btinternet.com>]

At 22:13 03/04/2014 +0000, Chris Dowling wrote:
>How do I put a line under a number to indicate it is a total or subtotal?

That depends on where you are!  Are you in a text (Writer) document, 
in a table in a text document, or perhaps in a spreadsheet?

In a spreadsheet:
o Select the relevant cell.
o Go to Format | Cells... | Borders (or right-click | Format Cells... 
| Borders).
o Under Line arrangement | User-defined, click at the bottom to 
indicate that you want the border only at the bottom of the cell.
o Under Line | Style, select your preferred line style and thickness.

Alternatively, you can click the down-arrow next to the Borders icon 
in the Formatting toolbar and select the icon for bottom border 
only.  This will give you the line but no option to select its 
style.  In addition, at Format | Cells... | Font Effects | 
Underlining you can select various styles of underlining.  Or you can 
use the Underline icon in the Formatting toolbar.  But note that 
underlining underlines only the value in the relevant cell, whereas a 
border extends the fill width of the cell - which I'd guess is what you want.

Underlining is also available in a text document, of course.  In a 
table in a text document, underlining of the value is available, but 
again you can alternatively apply a bottom border to a entire cell.

I trust this helps.

Brian Barker


-------------------------------------------
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: border line for total

[Alan B <ab...@gmail.com>]

On Thu, Apr 3, 2014 at 6:13 PM, Chris Dowling <do...@gmail.com>wrote:

> How do I put a line under a number to indicate it is a total or subtotal?
>

Ctrl+u  will underline a selection in pretty much every program I know of.
So select the number and press Ctrl+u

If you're using Calc and mean to put a bottom border on the cell containing
the number rather than underlining the number itself then do the
following...
- select the cell
- pick "Format | Cells..." from the menu
- click the "Borders" tab
- set the attributes for the underline from the options displayed