Excel 2000

  TonyV 15:33 07 Oct 2008
Locked

On a workbook which has two sheets, Income & Expenditure, on the Expenditure sheet there is a table which gives various categories of expenditure and the amount along with descriptions etc. The table is formatted to give a border all the way around and the table has both vertical and horizontal lines around each usable cell. My problem is that under the headings for the columns, there is a double line border. but from the last usable cell from that double line border there is a single line that has been drawn all the way to the very end of the sheet. IE.from Q4 to IV4!! How do I get rid of it?

I have tried everything from unlocking the sheet, though there is no protection on it to re applying the same format and then removing it.

This phenomenon does not apply to the Income Sheet!!

Thanks

TonyV

  VoG II 15:37 07 Oct 2008

Could it be as simple as Window > Unfreeze Panes?

  TonyV 15:40 07 Oct 2008

As ever, an absolute gem! (It must tempus fugit catching up on me!)

Many thanks

TonyV

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Adobe shows still-in-development tools, including automatically colourising black-and-white photos

iPhone X news: Release date, price, new features & specs

Comment transformer un iPhone en borne Wi-Fi ?