ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Interior borders (https://www.excelbanter.com/excel-discussion-misc-queries/50863-interior-borders.html)

Nicole

Interior borders
 
I would like to add interior borders to some of my cells in Excel. When I
right click in the cell and chose "Format Cells" and then "Border", I can see
that this is a possible option, however, it is grayed out and I cannot use it.

Seems like a simple task, but I am frustrated. Is there something I need to
load or activate to make this option available?

Anne Troy

Interior borders
 
Sounds like the sheet might be protected, Nicole.
************
Anne Troy
www.OfficeArticles.com

"Nicole" wrote in message
...
I would like to add interior borders to some of my cells in Excel. When I
right click in the cell and chose "Format Cells" and then "Border", I can
see
that this is a possible option, however, it is grayed out and I cannot use
it.

Seems like a simple task, but I am frustrated. Is there something I need
to
load or activate to make this option available?




Nicole

Interior borders
 
Thank you, Anne. However, it is a sheet that I created myself, and I just
double-checked to make sure I had not protected it - I didn't. Something
else must be going on. All the other border options are "on" including
interior diagonal lines. It is only the interior horizontal and vertical
lines that are "off."

"Anne Troy" wrote:

Sounds like the sheet might be protected, Nicole.
************
Anne Troy
www.OfficeArticles.com

"Nicole" wrote in message
...
I would like to add interior borders to some of my cells in Excel. When I
right click in the cell and chose "Format Cells" and then "Border", I can
see
that this is a possible option, however, it is grayed out and I cannot use
it.

Seems like a simple task, but I am frustrated. Is there something I need
to
load or activate to make this option available?





Anne Troy

Interior borders
 
The inside borders aren't available unless you select multiple cells. Then
the inside borders are placed "inside" the range of cells, not within the
inside of A cell.
************
Anne Troy
www.OfficeArticles.com

"Nicole" wrote in message
...
Thank you, Anne. However, it is a sheet that I created myself, and I just
double-checked to make sure I had not protected it - I didn't. Something
else must be going on. All the other border options are "on" including
interior diagonal lines. It is only the interior horizontal and vertical
lines that are "off."

"Anne Troy" wrote:

Sounds like the sheet might be protected, Nicole.
************
Anne Troy
www.OfficeArticles.com

"Nicole" wrote in message
...
I would like to add interior borders to some of my cells in Excel. When
I
right click in the cell and chose "Format Cells" and then "Border", I
can
see
that this is a possible option, however, it is grayed out and I cannot
use
it.

Seems like a simple task, but I am frustrated. Is there something I
need
to
load or activate to make this option available?







Nicole

Interior borders
 
Sure enough! Rookie error. Thanks Anne for all your help.

"Anne Troy" wrote:

The inside borders aren't available unless you select multiple cells. Then
the inside borders are placed "inside" the range of cells, not within the
inside of A cell.
************
Anne Troy
www.OfficeArticles.com

"Nicole" wrote in message
...
Thank you, Anne. However, it is a sheet that I created myself, and I just
double-checked to make sure I had not protected it - I didn't. Something
else must be going on. All the other border options are "on" including
interior diagonal lines. It is only the interior horizontal and vertical
lines that are "off."

"Anne Troy" wrote:

Sounds like the sheet might be protected, Nicole.
************
Anne Troy
www.OfficeArticles.com

"Nicole" wrote in message
...
I would like to add interior borders to some of my cells in Excel. When
I
right click in the cell and chose "Format Cells" and then "Border", I
can
see
that this is a possible option, however, it is grayed out and I cannot
use
it.

Seems like a simple task, but I am frustrated. Is there something I
need
to
load or activate to make this option available?







Anne Troy

Interior borders
 
Any time. :)
************
Anne Troy
www.OfficeArticles.com

"Nicole" wrote in message
...
Sure enough! Rookie error. Thanks Anne for all your help.

"Anne Troy" wrote:

The inside borders aren't available unless you select multiple cells.
Then
the inside borders are placed "inside" the range of cells, not within the
inside of A cell.
************
Anne Troy
www.OfficeArticles.com

"Nicole" wrote in message
...
Thank you, Anne. However, it is a sheet that I created myself, and I
just
double-checked to make sure I had not protected it - I didn't.
Something
else must be going on. All the other border options are "on" including
interior diagonal lines. It is only the interior horizontal and
vertical
lines that are "off."

"Anne Troy" wrote:

Sounds like the sheet might be protected, Nicole.
************
Anne Troy
www.OfficeArticles.com

"Nicole" wrote in message
...
I would like to add interior borders to some of my cells in Excel.
When
I
right click in the cell and chose "Format Cells" and then "Border",
I
can
see
that this is a possible option, however, it is grayed out and I
cannot
use
it.

Seems like a simple task, but I am frustrated. Is there something I
need
to
load or activate to make this option available?










All times are GMT +1. The time now is 11:54 PM.

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