Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation: How do I hide border of ACTIVE lists?
I can't seem to get rid of the big, bright blue border that surrounds the
entire range of data (the active list) when I click on a cell inside this range. I have several other spreadsheets that don't show this blue border, but they were built by someone else. Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation: How do I hide border of ACTIVE lists?
What you are seeing is not a Data Validation List.
It is a List created from DataCreate List which was introduced with Excel 2003. As long as that remains a list range you will see the blue borders. I know of no way to hide it. If you don't want it to be a list you can convert back to range. Enable the List Toolbar and click on List dropdown and select "Convert to Range". Gord Dibben MS Excel MVP On Fri, 5 Oct 2007 14:24:00 -0700, Tony wrote: I can't seem to get rid of the big, bright blue border that surrounds the entire range of data (the active list) when I click on a cell inside this range. I have several other spreadsheets that don't show this blue border, but they were built by someone else. Thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation: How do I hide border of ACTIVE lists?
Maybe you have a list created? select a cell within the list, then do
datalistconvert to range note that it will remove all list capabilities. Only other time I have seen blue borders is when I import xml data -- Regards, Peo Sjoblom "Tony" wrote in message ... I can't seem to get rid of the big, bright blue border that surrounds the entire range of data (the active list) when I click on a cell inside this range. I have several other spreadsheets that don't show this blue border, but they were built by someone else. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Data Validation Lists | Excel Worksheet Functions | |||
Data Validation (2 lists) | Excel Discussion (Misc queries) | |||
Data Validation with Lists | Excel Discussion (Misc queries) | |||
Data Validation Lists | Links and Linking in Excel |