ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   creating list (https://www.excelbanter.com/excel-worksheet-functions/135045-creating-list.html)

hannatrip

creating list
 
is there a way to get rid of the blue line that surrounds the cells when you
use lists?

Duke Carey

creating list
 
The Data-Lists... menu has an option to hide the border of INACTIVE lists



"hannatrip" wrote:

is there a way to get rid of the blue line that surrounds the cells when you
use lists?


hannatrip

creating list
 
i tried that but nothing happens

"Duke Carey" wrote:

The Data-Lists... menu has an option to hide the border of INACTIVE lists



"hannatrip" wrote:

is there a way to get rid of the blue line that surrounds the cells when you
use lists?


Roger Govier

creating list
 
Hi

Did you click outside of the List? The border is only removed when the
cursor is outside of the list.

--
Regards

Roger Govier


"hannatrip" wrote in message
...
i tried that but nothing happens

"Duke Carey" wrote:

The Data-Lists... menu has an option to hide the border of INACTIVE
lists



"hannatrip" wrote:

is there a way to get rid of the blue line that surrounds the cells
when you
use lists?




hannatrip

creating list
 
I just tried it but as soon as you click in the list it comes back.

"Roger Govier" wrote:

Hi

Did you click outside of the List? The border is only removed when the
cursor is outside of the list.

--
Regards

Roger Govier


"hannatrip" wrote in message
...
i tried that but nothing happens

"Duke Carey" wrote:

The Data-Lists... menu has an option to hide the border of INACTIVE
lists



"hannatrip" wrote:

is there a way to get rid of the blue line that surrounds the cells
when you
use lists?





Roger Govier

creating list
 
Yes, that's the way it behaves.
When the list is inactive, i.e. you are not within it, the borders are
hidden.
I am not aware of any method of suppressing borders whilst it is active.

--
Regards

Roger Govier


"hannatrip" wrote in message
...
I just tried it but as soon as you click in the list it comes back.

"Roger Govier" wrote:

Hi

Did you click outside of the List? The border is only removed when
the
cursor is outside of the list.

--
Regards

Roger Govier


"hannatrip" wrote in message
...
i tried that but nothing happens

"Duke Carey" wrote:

The Data-Lists... menu has an option to hide the border of
INACTIVE
lists



"hannatrip" wrote:

is there a way to get rid of the blue line that surrounds the
cells
when you
use lists?







hannatrip

creating list
 
ok, thanks, i thought maybe I could get rid of them all together

"Roger Govier" wrote:

Yes, that's the way it behaves.
When the list is inactive, i.e. you are not within it, the borders are
hidden.
I am not aware of any method of suppressing borders whilst it is active.

--
Regards

Roger Govier


"hannatrip" wrote in message
...
I just tried it but as soon as you click in the list it comes back.

"Roger Govier" wrote:

Hi

Did you click outside of the List? The border is only removed when
the
cursor is outside of the list.

--
Regards

Roger Govier


"hannatrip" wrote in message
...
i tried that but nothing happens

"Duke Carey" wrote:

The Data-Lists... menu has an option to hide the border of
INACTIVE
lists



"hannatrip" wrote:

is there a way to get rid of the blue line that surrounds the
cells
when you
use lists?







Gord Dibben

creating list
 
Only if you remove the list.


Gord Dibben MS Excel MVP

On Thu, 15 Mar 2007 13:18:26 -0700, hannatrip
wrote:

ok, thanks, i thought maybe I could get rid of them all together

"Roger Govier" wrote:

Yes, that's the way it behaves.
When the list is inactive, i.e. you are not within it, the borders are
hidden.
I am not aware of any method of suppressing borders whilst it is active.

--
Regards

Roger Govier


"hannatrip" wrote in message
...
I just tried it but as soon as you click in the list it comes back.

"Roger Govier" wrote:

Hi

Did you click outside of the List? The border is only removed when
the
cursor is outside of the list.

--
Regards

Roger Govier


"hannatrip" wrote in message
...
i tried that but nothing happens

"Duke Carey" wrote:

The Data-Lists... menu has an option to hide the border of
INACTIVE
lists



"hannatrip" wrote:

is there a way to get rid of the blue line that surrounds the
cells
when you
use lists?









All times are GMT +1. The time now is 10:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com