Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is range outlined in blue?
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? -- Smudge |
#2
|
|||
|
|||
Answer: Why is range outlined in blue?
Steps to remove blue outline in Excel:
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is range outlined in blue?
You havve track changes turned on. Go to tools menu and select track
changes. then uncheck box indicating you want to track changes "Smudge" wrote: 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? -- Smudge |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is range outlined in blue?
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 -- Smudge "Joel" wrote: You havve track changes turned on. Go to tools menu and select track changes. then uncheck box indicating you want to track changes "Smudge" wrote: 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? -- Smudge |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is range outlined in blue?
If using 2003 Excel you have the DataList function.
Select a range and DataCreate List. It will be outlined by a blue line. To get rid of a list right-click anywhere in the list and ListConvert to Range. Gord Dibben MS Excel MVP On Wed, 15 Aug 2007 12:24:07 -0700, Smudge wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is range outlined in blue?
Thank you Gord,
We think that this is what's been done Cheers -- Smudge "Gord Dibben" wrote: If using 2003 Excel you have the DataList function. Select a range and DataCreate List. It will be outlined by a blue line. To get rid of a list right-click anywhere in the list and ListConvert to Range. Gord Dibben MS Excel MVP On Wed, 15 Aug 2007 12:24:07 -0700, Smudge wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing Blue Border in xml mapped range | Excel Discussion (Misc queries) | |||
Outlined Data in Excel | Setting up and Configuration of Excel | |||
sorting a sheet with outlined rows | Excel Discussion (Misc queries) | |||
Compressed Outlined Data Copy | Excel Discussion (Misc queries) | |||
Range names are displaying in big blue letters on sheet | Excel Discussion (Misc queries) |