Thin blue vertical line on sheet

richlady39

New Member
Joined
Nov 30, 2014
Messages
2
Something just showed up on my excel 2010 - I am new to this version - it is a thin blue line - vertical - that has a "dot" at the top and bottom - is is running up and down the columns where I have figures. I've never seen anything like this before, How do I get rid of it....it moves each time I move to a different column....Thanks...Irene
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Re: Cannot remove line on spreadsheet

To remove all tracer arrows on the worksheet, on the Formulas tab, in the Formula Auditing group, click Remove Arrows Button image.

Most likely you have a circular reference in your formula
 
Last edited:
Upvote 0
Re: Cannot remove line on spreadsheet

Can you upload the workbook to a hosting site like Dropbox or Mediafire....then post the link to that site back here...we may be able to "see" the problem better that way !
 
Upvote 0
Re: Cannot remove line on spreadsheet

Mark858 - I think you are right about the circular reference - I was deleting all the figures from the spread sheet so that I can enter my new figures and then the line disappeared....it's no longer there.

I'll keep that in mind if it should turn up again as I enter all my figures..

Thanks very much for all answers...
 
Upvote 0

Forum statistics

Threads
1,216,022
Messages
6,128,324
Members
449,440
Latest member
Gillian McGovern

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top