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

Cheers Dave

That has took me one step further

When I enter design mode then goto-special-objects I can delete but it
deletes all my graphs as well which I can't have.

I have learnt that these black lines are actually minimized graphs from a
previous evaluation I have done. I have a master and just alter it each time.

When I do goto-special-objects I can extend the lines to get to the graphs
but then not delete them when they are maximised. When I tried cutting them
the PC crashed.

Cheers
"Dave Peterson" wrote:

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