View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Remove Black line above Data which include formulas

Maybe...

Show the control toolbox toolbar
(via View|toolbars|control toolbox)

Click on the design mode icon.

Try selecting the object and hitting the delete key on the keyboard.

If you don't have any objects you want to keep, you can delete them via:

Edit|goto|special|objects
and hit the delete key

When you're done, turn off the design mode (click that button again)

Apples wrote:

Hi any help much appreciated.

I am doing an evaluation of a project and as such have lots of sections on
the worksheet which have a question, then the number of people who answered
excellant,poor etc then in the next column a percentage row.

Above 2 of these sections I now have a solid black line which prints. The
black line cannot be selected, it is not a border and prints. When I hover
over it I do not get any options.

How do I get rid of it?

Many thanks


--

Dave Peterson