Ask Your Question
0

Border width adjustment not responding [closed]

asked 2017-02-19 13:50:53 +0100

appreciatethehelp gravatar image

Hello. Have been trying to change the right hand border width on the cells in column K in this document:

C:\fakepath\WATER INTAKE & EXERCISE TALLY.ods

So I highlighted the cells in column K, went to format > page > borders, selected the right-hand border from the "user defined" box on the left, then adjusted the line width to 1.50pt. However, when I click "OK" and return to the document, no change has been made to the right hand border width of the cells in column K- they are still the same width.

Is there another way to do this?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-02-21 19:00:23.168810

2 Answers

Sort by » oldest newest most voted
1

answered 2017-02-19 14:27:18 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

What I found is, not to use page > borders, but instead use cells > borders. (You can also get this by highlighting the cells and right-clicking, then on popup menu find Format Cells ..., then go to Borders)

Then the tricky thing is to first select the part of the cell(s) you want in the diagram, then the width. Unlike Excel, the new thickness won't display in the diagram - you have to check in the spreadsheet itself.

Cheers and hope this helps.

edit flag offensive delete link more

Comments

But of course! Thanks

appreciatethehelp gravatar imageappreciatethehelp ( 2017-02-21 19:00:10 +0100 )edit
2

answered 2017-02-19 14:27:53 +0100

Lupp gravatar image

Why do you look for page borders? Go RightClick 'Format Cells...' or Menu 'Format' > 'Cells...' and then 'Borders'.

edit flag offensive delete link more

Comments

But of course! Thanks.

appreciatethehelp gravatar imageappreciatethehelp ( 2017-02-21 18:59:20 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2017-02-19 13:50:53 +0100

Seen: 22 times

Last updated: Feb 19