Josh NZ Posted November 9, 2016 Share Posted November 9, 2016 I have a worksheet which im wanting to show with an outline to the perimeter only. Have gone into the format cells dialog and unticked "inside". Then ticked "outside". In the review it appears how I want it to. As soon as I exit thou every cell has a border. What am I missing? Quote Link to comment
michaelk Posted November 9, 2016 Share Posted November 9, 2016 You would be correct if you weren't in the database portion of the worksheet. In a data base, any border you put in one cell you do to all database subrow cells in that column. You need to put a right border on the right column, a left border on the left column, a bottom border on the row above and a top border on the row below. hth mk 1 Quote Link to comment
Josh NZ Posted November 9, 2016 Author Share Posted November 9, 2016 Thanks for that Michael, did the above and achieved what i'm after. For anyone else it would probably also pay to note that the line style needs to be set to none in the Attributes palette. I left mine as solid black and every cell still showed up with a border. It was only once I changed the line type to none that only the outline showed up. Quote Link to comment
michaelk Posted November 9, 2016 Share Posted November 9, 2016 The outline around the entire worksheet is controlled by the object attributes, like any other VW object. Same with the fill. The grey lines are turned on and off in worksheet preferences. You can make the cell border line style be anything you want in cell formatting. mk Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.