Excel 2000

  TonyV 15:33 07 Oct 08

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!!



  VoG II 15:37 07 Oct 08

Could it be as simple as Window > Unfreeze Panes?

  TonyV 15:40 07 Oct 08

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

Many thanks


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

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…