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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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,223,099
Messages
6,170,112
Members
452,302
Latest member
TaMere

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