I am fluent in Excel and have a strange line that I can't get rid of. I have
created a dashboard type report and in the middle there is a line that runs
between two rows. I want to delete it. I tried to format the cells with no
line (there isn't one showing), I tried to grab an object line that may have
been added - there is none. I tried to delete the two rows surrounding it
and the line remains. It's not a page break - I checked, I even turned off
the gridline and to no avail. I wouldn't care so much if it just didn't
print, but it does.

Any ideas how to get rid of it or even what it is?

I understand how frustrating it can be when you have a line in your Excel sheet that you can't seem to get rid of. Here are a few steps you can try to remove the line:

1. Check if the line is a border: Select the cells around the line and go to the "Home" tab in the ribbon. Click on the "Borders" drop-down menu and select "No Border". This should remove any borders that may be causing the line to appear.
   
2. Check if the line is a shape: Sometimes, lines can be added as shapes in Excel. To check if this is the case, go to the "Insert" tab in the ribbon and click on "Shapes". Look for any shapes that may be causing the line to appear and delete them.
   
3. Check if the line is a chart element: If you have any charts in your Excel sheet, it's possible that the line is a chart element. To check this, select the chart and go to the "Chart Tools" tab in the ribbon. Click on "Format" and look for any chart elements that may be causing the line to appear. Delete them if necessary.
   
4. Check if the line is a conditional formatting rule: It's possible that the line is a result of a conditional formatting rule. To check this, select the cells around the line and go to the "Home" tab in the ribbon. Click on "Conditional Formatting" and select "Clear Rules" "Clear Rules from Selected Cells". This should remove any conditional formatting rules that may be causing the line to appear.

If none of these steps work, it's possible that the line is a result of a glitch in Excel. In this case, you may need to try closing and reopening the Excel sheet or even restarting your computer. I hope this helps you get rid of the line!

Could there be some type of conditional formatting in that area? Just a
thought.

--

"JICDB" wrote in message
...
I am fluent in Excel and have a strange line that I can't get rid of. I
have
created a dashboard type report and in the middle there is a line that
runs
between two rows. I want to delete it. I tried to format the cells with
no
line (there isn't one showing), I tried to grab an object line that may
have
been added - there is none. I tried to delete the two rows surrounding it
and the line remains. It's not a page break - I checked, I even turned
off
the gridline and to no avail. I wouldn't care so much if it just didn't
print, but it does.

Any ideas how to get rid of it or even what it is?

Could it be an object (squished when you deleted a row???) -- like a button???

Try showing the control toolbox toolbar
click on the design mode icon
then try selecting (and deleting) it.

JICDB wrote:

I am fluent in Excel and have a strange line that I can't get rid of. I have
created a dashboard type report and in the middle there is a line that runs
between two rows. I want to delete it. I tried to format the cells with no
line (there isn't one showing), I tried to grab an object line that may have
been added - there is none. I tried to delete the two rows surrounding it
and the line remains. It's not a page break - I checked, I even turned off
the gridline and to no avail. I wouldn't care so much if it just didn't
print, but it does.

Any ideas how to get rid of it or even what it is?

--

Dave Peterson

It sounds like a chart or shape object that got shrunk to zero height when
the rows containing it were deleted. A chart at least, when shrunk to zero
height, won't let you grab it according to my tests. There are probably some
controls that do likewise.

To test my theory and fix the problem, put the Select Multiple Objects
button on your toolbar and check to see what objects are listed (sheet must
not be protected or you won't see them). This calls a dialog that lets you
select the objects. I suspect you'll find a chart, control or drawing object
you weren't aware of.

To access the Select Multiple Objects button:
Right click any toolbar Customize Commands tab Select Drawing from the
categories list. Then drag the Select Multiple Objects button to the toolbar.
I have it as 3rd from the top in the Commands list.

Greg

OK - I started from the PCLIVE's response and worked my way down through
Dave's and then Gregs. No conditional formatiing (but great idea). I had
been trying to grab it and delete it but to no avail. I couldn't get the
design mode button to really be effective. Greg's idea, similar to Dave's
worked great. I used the Multiple objects tool bar to eliminate the hundreds
of charts, text boxes, pictures, and auto shapes to find the 10 objects that
got squished in the middle somehow.

Thanks for the collabrative effort. I thought I was going crazy.

"JICDB" wrote:

I am fluent in Excel and have a strange line that I can't get rid of. I have
created a dashboard type report and in the middle there is a line that runs
between two rows. I want to delete it. I tried to format the cells with no
line (there isn't one showing), I tried to grab an object line that may have
been added - there is none. I tried to delete the two rows surrounding it
and the line remains. It's not a page break - I checked, I even turned off
the gridline and to no avail. I wouldn't care so much if it just didn't
print, but it does.

Any ideas how to get rid of it or even what it is?

Happens when you delete rows/columns where they were

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JICDB" wrote in message
...
OK - I started from the PCLIVE's response and worked my way down through
Dave's and then Gregs. No conditional formatiing (but great idea). I had
been trying to grab it and delete it but to no avail. I couldn't get the
design mode button to really be effective. Greg's idea, similar to Dave's
worked great. I used the Multiple objects tool bar to eliminate the
hundreds
of charts, text boxes, pictures, and auto shapes to find the 10 objects
that
got squished in the middle somehow.

Thanks for the collabrative effort. I thought I was going crazy.

"JICDB" wrote:

I am fluent in Excel and have a strange line that I can't get rid of. I
have
created a dashboard type report and in the middle there is a line that
runs
between two rows. I want to delete it. I tried to format the cells with
no
line (there isn't one showing), I tried to grab an object line that may
have
been added - there is none. I tried to delete the two rows surrounding
it
and the line remains. It's not a page break - I checked, I even turned
off
the gridline and to no avail. I wouldn't care so much if it just didn't
print, but it does.

Any ideas how to get rid of it or even what it is?