Why is range outlined in blue?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm apologising at the start of this post 'cos it is so non specific :-)

A colleague has a spreadsheet with a range of cells outlined in blue (15+
rows x 1 col). we've checked out borders and also whether it's the range
highlighted as part of an advanced filter, but neither of these.

It is a case of blind leading the blind in our office so any help would be
appreciated!

Any suggestions?
 
You havve track changes turned on. Go to tools menu and select track
changes. then uncheck box indicating you want to track changes
 
Hi Joel,

I don't think it's tracked changes but hard to tell :-) My colleague managed
to get rid of the blue line but doesn't know how. she deleted the column but
also made other changes so doesn't know what did it. so annoying when you
don't get to the bottom of things.

I tried out track changes on another spreadsheet and it didn't look anything
like the blue outline - individual cells were outlined in track changes but
our strange outline was just the outside of the rows and columns

Thank you anyway

Cheers
 
If using 2003 Excel you have the Data>List function.

Select a range and Data>Create List.

It will be outlined by a blue line.

To get rid of a list right-click anywhere in the list and List>Convert to Range.


Gord Dibben MS Excel MVP
 
Back
Top