Unwanted horizontal line

%3CLINGO-SUB%20id%3D%22lingo-sub-49763%22%20slang%3D%22en-US%22%3EUnwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49763%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20Excel%202003.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20continuous%20line%20under%207%20cells%2C%20although%20only%20partly%20under%20the%20first%20and%20last%20cells.%20The%20line%20looks%20like%20a%20bottom%20border%2C%20but%20it%20is%20not%20because%20I%20cannot%20remove%20it%20with%20border%20formatting.%20If%20I%20remove%20the%20rows%20containing%20the%20line%2C%20the%20line%26nbsp%3Bjumps%20up%20a%20couple%20of%20rows.%20If%26nbsp%3BI%20remove%20the%20columns%20containing%20the%20line%2C%20it's%20gone%20but%20so%20are%20my%26nbsp%3Bdata%20and%20formulas.%20When%20I%20make%20a%20chart%20on%20top%20of%20the%20line%2C%20the%20line%20shows%20through%20the%20chart%20and%20when%20I%20copy%20the%20chart%2C%20the%20line%20comes%20with%20it.%20How%20can%26nbsp%3BI%20remove%20this%20stupid%20line%20(which%20is%20now%20copied%20all%20over%20the%20place)%20without%20changing%20anything%20else%20on%20the%20worksheet%3F%20And%20also%20important%2C%20how%20do%20I%20avoid%20this%20happening%20again%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20the%20tip%2C%20as%20my%20work%20colleagues%26nbsp%3Bdon't%20know%20how%20to%20solve%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-49763%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49859%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49859%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20you're%20right.%20But%20probably%20you%20know%20that%20once%20a%20%3CU%3Enormal%20private%20user%3C%2FU%3E%20has%20bought%20Office%202003%2C%20there%20isn't%20much%20incentive%20to%20buy%20a%20newer%20version%20and%20then%20have%20to%20learn%20all%20the%20new%20icons%20and%20menus.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20way%20round%20this%20problem%20for%20Microsoft%20is%20to%20withdraw%20the%20old%20product%2C%20plus%20convince%20the%20big%20users%20to%20upgrade.%20The%20same%20applies%20to%20Windows.%20W-10%20was%20offered%20free%2C%20but%20I%20didn't%20take%20the%20offer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20MS%20will%20get%20me%20in%20the%20end!%20That's%20alright.%20It's%20the%26nbsp%3Bproblem%20that%20software%20doesn't%20wear%20out.%20For%20some%20customers%20you%20have%20to%20wait%20till%20their%20hardware%20wears%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49854%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49854%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20yes%20of%20course%2C%20I%20must%20have%20been%20too%20light%20on%20the%26nbsp%3Bcontrol%20key.%20Problem%20solved%2C%20many%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49852%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49852%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20for%20jumping%20in%20with%20off-topic%3C%2FP%3E%3CP%3E%3CSPAN%3E%22Excel%202003%2C%20normally%20an%20excellent%20product%20with%20no%20other%20problems!%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAgree%2C%20Excel%20in%20general%20is%20quite%20excellent%20product.%20However%2C%26nbsp%3BExcel%202003%20is%20not%20supported%20for%20about%207%20years%2C%20and%20even%20if%20it%20has%20no%20other%20problems%20it%20doesn't%20have%20a%20lot%20of%20other%20possibilities%26nbsp%3Bcompare%20to%20latest%20versions.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EBut%20John%2C%20that's%20your%20business%2C%20just%20a%20comment.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49851%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49851%22%20slang%3D%22en-US%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F41909%22%20target%3D%22_blank%22%3E%40John%20F.%20Davies%3C%2FA%3E%20wrote%3A%3CBR%20%2F%3E%3CP%3EIs%20there%20a%20way%20to%20deselect%20the%20charts%20so%20that%20I%20don't%20have%20to%20move%20them%20to%20and%20fro%3F%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3EIt's%20like%20any%20other%20mutliple%20selection%3A%20Hold%20the%20CTRL-key%20and%20click%20on%20the%20chart.%20It%20should%20be%20de-selected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49847%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49847%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20it%20works.%20With%20Control-G%2C%20Special%2C%20Objects%2C%20all%26nbsp%3Bthe%26nbsp%3Bunwanted%20lines%20are%20selected%2C%20which%20I%20can%20then%20delete%20in%20one%20go.%20Since%26nbsp%3Ball%20the%20charts%20are%20also%20selected%2C%20I%20first%20had%20to%20copy%20them%20to%20another%20sheet%2C%20and%20then%20after%20the%20deletion%20of%20the%20lines%2C%26nbsp%3BI%20copied%20them%20back%20again.%20Is%20there%20a%20way%20to%20deselect%20the%20charts%20so%20that%20I%20don't%20have%20to%20move%20them%20to%20and%20fro%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49811%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49811%22%20slang%3D%22en-US%22%3E%3CP%3EHuh...%20try%20CTRL-G%20then.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49809%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49809%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20your%20patience.%20Perhaps%20you%20do%20not%20see%20the%20lines%20because%20of%20software%20differences.%20I%20am%20using%20Excel%202003%2C%20normally%20an%20excellent%20product%20with%20no%20other%20problems!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETherefore%20I%20send%20you%20the%20attached%20screenshot%20in%20a%20Word%20file%20as%20a%20object%20and%20you%20cannot%20fail%20to%20see%20the%20lines%20with%26nbsp%3Bvarying%20length%20and%20also%20the%20most%20peculiar%20one%20between%20lines%2017%20and%2018%20which%20is%20both%20on%20the%20worksheet%20and%20on%20top%20of%20the%20chart.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20my%20HP%2C%20pressing%20the%20F5%20key%20only%20causes%20an%20exit%20from%20the%20worksheet.%20Please%20explain%20how%20I%20can%20select%20the%20line%20without%20using%20F5%20and%20without%20using%20the%20mouse.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49801%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49801%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20first%20impression%3A%20There%20are%20no%20lines.%3C%2FP%3E%3CP%3EI%20switched%20off%20the%20gridlines%20and%20deleted%20the%20chart.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20second%20impression%3A%20There%20are%20no%20lines.%3C%2FP%3E%3CP%3EI%20pressed%20F5%2C%20clicked%20%22Special...%22%20and%20selected%20%22Objects%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20third%20impression%3A%20Suddenly%20there%20seem%20to%20be%20some%20lines.%20But%20they%20have%20a%20heigth%20of%200%20cm.%20That's%20why%20you%20couldn't%20select%20them%20with%20the%20mouse.%3C%2FP%3E%3CP%3EKeep%20them%20selected%20and%20press%20DEL.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49798%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49798%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20it%20is.%20I%20have%20deleted%20all%20data%2C%20but%20you%20can%20see%20a%20sample%20of%20the%20offending%20lines.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20there%20are%26nbsp%3B6%20of%20them%20between%20A2..AA4%20of%20varying%20lengths%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20one%20at%20lines%2017%2F18%20under%20and%20showing%20through%20the%20chart.%20There%20is%20a%20further%20one%20at%20%26nbsp%3BL34..R35%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20you%20get%20the%20file.%20BTW%20I%20have%20the%20same%20problem%20on%20other%20worksheets%20independent%20of%20this%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49796%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49796%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20no%20more%20ideas.%3C%2FP%3E%3CP%3ECould%20you%20upload%20your%20file%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49788%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49788%22%20slang%3D%22en-US%22%3E%3CP%3ENothing%20happens%20to%20the%20line%20because%20it%20is%20not%20attached%20to%20the%20chart%2C%20it%20is%20attached%20to%20the%20spreadsheet%2C%20so%20it%20stays%20there.%20I%20probably%20misled%26nbsp%3Byou%20by%20saying%26nbsp%3Bthat%20when%20I%20copy%20the%20chart%2C%20the%20mystery%20line%20goes%20with%20it.%20This%20is%20true%20only%20because%20I%20am%20copying%20both%20the%20chart%20and%20the%20linked%20data%20in%20one%20go%20to%20another%20location%2C%20so%20I%20select%20all%20the%20cells%2C%20and%20then%20of%20course%20the%20mystery%20line%20is%20copied%20too.%20But%20it%20is%20not%20attached%20to%20the%20chart.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20chart%20masks%20out%20the%20gridlines%20but%20the%20chart%20does%20not%20mask%20out%20the%20mystery%20line.%20If%20I%20write%20%22abc%22%20in%20a%20cell%20and%20then%20put%20the%20chart%20on%20top%20of%20it%2C%20I%20don't%20see%20the%20%22abc%22%20of%20course.%20But%20I%20do%20see%20this%20stupid%20line.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49786%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49786%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20happens%20if%20you%20remove%20the%20chart%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49785%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49785%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20line%20is%26nbsp%3Bnot%20selectable.%20It%20is%20a%20line%20looking%20the%20same%20as%20a%20border%20line%20and%20is%20positioned%20exactly%20on%20the%20gridline%20between%20two%20rows.%20It%20does%20not%20occupy%20any%20area.%20If%26nbsp%3BI%20place%20the%20cursor%20in%20the%20column%20anywhere%20above%20or%20below%20the%20line%20and%20insert%20a%20column%2C%20the%20mystery%20line%20gets%20longer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMost%20irritating%20is%20that%20it%20shows%20up%20as%20a%20horizontal%20line%20on%20a%20chart%20which%20is%20placed%20on%20top%20of%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49775%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49775%22%20slang%3D%22en-US%22%3E%3CP%3EI%20could%20be%20an%20object.%3C%2FP%3E%3CP%3ETry%20selecting%20it%20and%20hit%20the%20DEL-key.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49770%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49770%22%20slang%3D%22en-US%22%3E%3CP%3ENo%2C%20because%20it%20doesn't%20fully%20extend%20over%20the%20first%20and%20last%20cells.%20I%20don't%20think%20that%20you%20can%20make%20a%20border%20in%20only%20part%20of%20a%20cell.%20Anyway%2C%20if%20I%20remove%20all%20the%20rows%20at%2C%26nbsp%3Babove%20and%20below%20the%20line%2C%26nbsp%3Bthe%26nbsp%3Bborder%20can't%20jump%20up%20to%20occupy%20other%20rows%2C%20can%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-49769%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20horizontal%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49769%22%20slang%3D%22en-US%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F41909%22%20target%3D%22_blank%22%3E%40John%20F.%20Davies%3C%2FA%3E%20wrote%3A%3CBR%20%2F%3E%3CP%3E%26nbsp%3B%3C%2FP%3EThe%20line%20looks%20like%20a%20bottom%20border%2C%20but%20it%20is%20not%20because%20I%20cannot%20remove%20it%20with%20border%20formatting.%3C%2FBLOCKQUOTE%3E%3CP%3EPerhaps%20it%20is%20an%20upper%20border.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have Excel 2003.

 

I have a continuous line under 7 cells, although only partly under the first and last cells. The line looks like a bottom border, but it is not because I cannot remove it with border formatting. If I remove the rows containing the line, the line jumps up a couple of rows. If I remove the columns containing the line, it's gone but so are my data and formulas. When I make a chart on top of the line, the line shows through the chart and when I copy the chart, the line comes with it. How can I remove this stupid line (which is now copied all over the place) without changing anything else on the worksheet? And also important, how do I avoid this happening again?

 

Thanks in advance for the tip, as my work colleagues don't know how to solve it.

17 Replies

@John F. Davies wrote:

 

The line looks like a bottom border, but it is not because I cannot remove it with border formatting.

Perhaps it is an upper border.

 

No, because it doesn't fully extend over the first and last cells. I don't think that you can make a border in only part of a cell. Anyway, if I remove all the rows at, above and below the line, the border can't jump up to occupy other rows, can it?

I could be an object.

Try selecting it and hit the DEL-key.

 

The line is not selectable. It is a line looking the same as a border line and is positioned exactly on the gridline between two rows. It does not occupy any area. If I place the cursor in the column anywhere above or below the line and insert a column, the mystery line gets longer.

 

Most irritating is that it shows up as a horizontal line on a chart which is placed on top of it.

What happens if you remove the chart?

 

Nothing happens to the line because it is not attached to the chart, it is attached to the spreadsheet, so it stays there. I probably misled you by saying that when I copy the chart, the mystery line goes with it. This is true only because I am copying both the chart and the linked data in one go to another location, so I select all the cells, and then of course the mystery line is copied too. But it is not attached to the chart.

 

The chart masks out the gridlines but the chart does not mask out the mystery line. If I write "abc" in a cell and then put the chart on top of it, I don't see the "abc" of course. But I do see this stupid line.

I have no more ideas.

Could you upload your file?

 

 

Here it is. I have deleted all data, but you can see a sample of the offending lines.

 

For example there are 6 of them between A2..AA4 of varying lengths

 

There is one at lines 17/18 under and showing through the chart. There is a further one at  L34..R35

 

I hope you get the file. BTW I have the same problem on other worksheets independent of this one.

 

 

My first impression: There are no lines.

I switched off the gridlines and deleted the chart.

 

My second impression: There are no lines.

I pressed F5, clicked "Special..." and selected "Objects".

 

My third impression: Suddenly there seem to be some lines. But they have a heigth of 0 cm. That's why you couldn't select them with the mouse.

Keep them selected and press DEL.

 

Thank you for your patience. Perhaps you do not see the lines because of software differences. I am using Excel 2003, normally an excellent product with no other problems!

 

Therefore I send you the attached screenshot in a Word file as a object and you cannot fail to see the lines with varying length and also the most peculiar one between lines 17 and 18 which is both on the worksheet and on top of the chart.

 

On my HP, pressing the F5 key only causes an exit from the worksheet. Please explain how I can select the line without using F5 and without using the mouse.

Huh... try CTRL-G then.

 

Thanks, it works. With Control-G, Special, Objects, all the unwanted lines are selected, which I can then delete in one go. Since all the charts are also selected, I first had to copy them to another sheet, and then after the deletion of the lines, I copied them back again. Is there a way to deselect the charts so that I don't have to move them to and fro?


@John F. Davies wrote:

Is there a way to deselect the charts so that I don't have to move them to and fro?


It's like any other mutliple selection: Hold the CTRL-key and click on the chart. It should be de-selected.

 

Sorry for jumping in with off-topic

"Excel 2003, normally an excellent product with no other problems!"

 

Agree, Excel in general is quite excellent product. However, Excel 2003 is not supported for about 7 years, and even if it has no other problems it doesn't have a lot of other possibilities compare to latest versions.

 

But John, that's your business, just a comment.

 

 

Thanks, yes of course, I must have been too light on the control key. Problem solved, many thanks.

Yes, you're right. But probably you know that once a normal private user has bought Office 2003, there isn't much incentive to buy a newer version and then have to learn all the new icons and menus.

 

The only way round this problem for Microsoft is to withdraw the old product, plus convince the big users to upgrade. The same applies to Windows. W-10 was offered free, but I didn't take the offer.

 

However, MS will get me in the end! That's alright. It's the problem that software doesn't wear out. For some customers you have to wait till their hardware wears out.

If it was a table you removed filters & some formatting from, try Click Table Design, then Convert to Range to remove Table