Strange border format.

I got the mail, it was just border formatting (Format Cells Border) and
the cell colour set to white. I tried to mail the corrected file to you but
it bounced back to me saying the address you used was invalid,
Regards,
Alan.
"Rodney" wrote in message
...
G'day Alan,

I'll strip the bulk of the columns, and email forthwith
(It's probably something really simple and obvious)

Regards




"Alan" wrote in message
...
| Looked at you example. Please send me the file (if you want to) I'm
really
| quite curious,
| If you decide to do so please use
|
| Remove NOSPAM for obvious reasons,
| Regards,
| "Rodney" wrote in message
| ...
|
| In my sheet, I have a bunch of cells that have dotted borders,
| I cannot change this under format.
| When I add a column alongside, that part of the column offers no
| gridlines at all, all is blank.
|
| How do I rectify this please, and get back to naormal cell border
format?
|
| Thank you.
|
|
|
|
|
|
|

G'day Alan,
I still cannot get it.
I select the cells, FormatCellsBorder
select Outline and Inside.
Select colour to Automatic
Enter
The cell borders lose the dots but become darker
I cannot with any matrix get the cell borders back
to that dull grey colour, as in the rest of the sheet.



"Alan" wrote in message ...
| I got the mail, it was just border formatting (Format Cells Border) and
| the cell colour set to white. I tried to mail the corrected file to you but
| it bounced back to me saying the address you used was invalid,
| Regards,
| Alan.
| "Rodney" wrote in message
| ...
| G'day Alan,
|
| I'll strip the bulk of the columns, and email forthwith
| (It's probably something really simple and obvious)
|
| Regards
|
|
|
|
| "Alan" wrote in message
| ...
| | Looked at you example. Please send me the file (if you want to) I'm
| really
| | quite curious,
| | If you decide to do so please use
| |
| | Remove NOSPAM for obvious reasons,
| | Regards,
| | "Rodney" wrote in message
| | ...
| |
| | In my sheet, I have a bunch of cells that have dotted borders,
| | I cannot change this under format.
| | When I add a column alongside, that part of the column offers no
| | gridlines at all, all is blank.
| |
| | How do I rectify this please, and get back to naormal cell border
| format?
| |
| | Thank you.
| |
| |
| |
| |
| |
| |
| |
|
|
|
|

Select "None," if you want gridlines only (no borders).

"Rodney" wrote:


G'day Alan,
I still cannot get it.
I select the cells, FormatCellsBorder
select Outline and Inside.

If you highlight the range, right click, 'Format Cells' 'Borders' you will
see the edges of the cells shown in a fuzzy sort of way which indicates
there is more than one type of border present. Click 'None' as Ian Roy
suggests, click both the external and internal icons to the right of the
box, OK.
Now the dots are gone but you have no dull grey borders as you describe them
which are the standard gridlines in XL.
Highlight the range again, right click, 'Format Cells' 'Patterns' Click
'No Colour' This will set the range back to the status quo, in your file.
The cell colour in that range is white which means gridlines are not
displayed.
Regards,
Alan.
"Rodney" wrote in message
...

G'day Alan,
I still cannot get it.
I select the cells, FormatCellsBorder
select Outline and Inside.
Select colour to Automatic
Enter
The cell borders lose the dots but become darker
I cannot with any matrix get the cell borders back
to that dull grey colour, as in the rest of the sheet.



"Alan" wrote in message
...
| I got the mail, it was just border formatting (Format Cells Border)
and
| the cell colour set to white. I tried to mail the corrected file to you
but
| it bounced back to me saying the address you used was invalid,
| Regards,
| Alan.
| "Rodney" wrote in message
| ...
| G'day Alan,
|
| I'll strip the bulk of the columns, and email forthwith
| (It's probably something really simple and obvious)
|
| Regards
|
|
|
|
| "Alan" wrote in message
| ...
| | Looked at you example. Please send me the file (if you want to) I'm
| really
| | quite curious,
| | If you decide to do so please use
| |
| | Remove NOSPAM for obvious reasons,
| | Regards,
| | "Rodney" wrote in message
| | ...
| |
| | In my sheet, I have a bunch of cells that have dotted borders,
| | I cannot change this under format.
| | When I add a column alongside, that part of the column offers no
| | gridlines at all, all is blank.
| |
| | How do I rectify this please, and get back to naormal cell border
| format?
| |
| | Thank you.
| |
| |
| |
| |
| |
| |
| |
|
|
|
|

Goodness Gracious! finally.
Thank you very much indeed. (Alan and Ian)

Where I got nobbled was the "No Color" bar,
didn't see it, I must have clicked every color imaginable.
(I mean, it couldn't be much bigger, could it

I am a philatelist, and such occurrences when met looking
in a Catalogue for an issue is referred to as "catalogue blindness".

In MSWorks, setting gridlines and font to "white" was one workaround
for protecting discreet info.




"Alan" wrote in message ...
| If you highlight the range, right click, 'Format Cells' 'Borders' you will
| see the edges of the cells shown in a fuzzy sort of way which indicates
| there is more than one type of border present. Click 'None' as Ian Roy
| suggests, click both the external and internal icons to the right of the
| box, OK.
| Now the dots are gone but you have no dull grey borders as you describe them
| which are the standard gridlines in XL.
| Highlight the range again, right click, 'Format Cells' 'Patterns' Click
| 'No Colour' This will set the range back to the status quo, in your file.
| The cell colour in that range is white which means gridlines are not
| displayed.
| Regards,
| Alan.
| "Rodney" wrote in message
| ...
|
| G'day Alan,
| I still cannot get it.
| I select the cells, FormatCellsBorder
| select Outline and Inside.
| Select colour to Automatic
| Enter
| The cell borders lose the dots but become darker
| I cannot with any matrix get the cell borders back
| to that dull grey colour, as in the rest of the sheet.
|
|
|
| "Alan" wrote in message
| ...
| | I got the mail, it was just border formatting (Format Cells Border)
| and
| | the cell colour set to white. I tried to mail the corrected file to you
| but
| | it bounced back to me saying the address you used was invalid,
| | Regards,
| | Alan.
| | "Rodney" wrote in message
| | ...
| | G'day Alan,
| |
| | I'll strip the bulk of the columns, and email forthwith
| | (It's probably something really simple and obvious)
| |
| | Regards
| |
| |
| |
| |
| | "Alan" wrote in message
| | ...
| | | Looked at you example. Please send me the file (if you want to) I'm
| | really
| | | quite curious,
| | | If you decide to do so please use
| | |
| | | Remove NOSPAM for obvious reasons,
| | | Regards,
| | | "Rodney" wrote in message
| | | ...
| | |
| | | In my sheet, I have a bunch of cells that have dotted borders,
| | | I cannot change this under format.
| | | When I add a column alongside, that part of the column offers no
| | | gridlines at all, all is blank.
| | |
| | | How do I rectify this please, and get back to naormal cell border
| | format?
| | |
| | | Thank you.
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| |
| |
| |
| |
|
|
|
|

Thanks for the feedback. Glad you got it sorted out.

"Rodney" wrote:

Goodness Gracious! finally.
Thank you very much indeed. (Alan and Ian)

Where I got nobbled was the "No Color" bar,
didn't see it, I must have clicked every color imaginable.
(I mean, it couldn't be much bigger, could it

I am a philatelist, and such occurrences when met looking
in a Catalogue for an issue is referred to as "catalogue blindness".

In MSWorks, setting gridlines and font to "white" was one workaround
for protecting discreet info.




"Alan" wrote in message ...
| If you highlight the range, right click, 'Format Cells' 'Borders' you will
| see the edges of the cells shown in a fuzzy sort of way which indicates
| there is more than one type of border present. Click 'None' as Ian Roy
| suggests, click both the external and internal icons to the right of the
| box, OK.
| Now the dots are gone but you have no dull grey borders as you describe them
| which are the standard gridlines in XL.
| Highlight the range again, right click, 'Format Cells' 'Patterns' Click
| 'No Colour' This will set the range back to the status quo, in your file.
| The cell colour in that range is white which means gridlines are not
| displayed.
| Regards,
| Alan.
| "Rodney" wrote in message
| ...
|
| G'day Alan,
| I still cannot get it.
| I select the cells, FormatCellsBorder
| select Outline and Inside.
| Select colour to Automatic
| Enter
| The cell borders lose the dots but become darker
| I cannot with any matrix get the cell borders back
| to that dull grey colour, as in the rest of the sheet.
|
|
|
| "Alan" wrote in message
| ...
| | I got the mail, it was just border formatting (Format Cells Border)
| and
| | the cell colour set to white. I tried to mail the corrected file to you
| but
| | it bounced back to me saying the address you used was invalid,
| | Regards,
| | Alan.
| | "Rodney" wrote in message
| | ...
| | G'day Alan,
| |
| | I'll strip the bulk of the columns, and email forthwith
| | (It's probably something really simple and obvious)
| |
| | Regards
| |
| |
| |
| |
| | "Alan" wrote in message
| | ...
| | | Looked at you example. Please send me the file (if you want to) I'm
| | really
| | | quite curious,
| | | If you decide to do so please use
| | |
| | | Remove NOSPAM for obvious reasons,
| | | Regards,
| | | "Rodney" wrote in message
| | | ...
| | |
| | | In my sheet, I have a bunch of cells that have dotted borders,
| | | I cannot change this under format.
| | | When I add a column alongside, that part of the column offers no
| | | gridlines at all, all is blank.
| | |
| | | How do I rectify this please, and get back to naormal cell border
| | format?
| | |
| | | Thank you.
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| |
| |
| |
| |
|
|
|
|

Nice one, got there in the end!
Regards,
Alan.
"Rodney" wrote in message
...
Goodness Gracious! finally.
Thank you very much indeed. (Alan and Ian)

Where I got nobbled was the "No Color" bar,
didn't see it, I must have clicked every color imaginable.
(I mean, it couldn't be much bigger, could it

I am a philatelist, and such occurrences when met looking
in a Catalogue for an issue is referred to as "catalogue blindness".

In MSWorks, setting gridlines and font to "white" was one workaround
for protecting discreet info.




"Alan" wrote in message
...
| If you highlight the range, right click, 'Format Cells' 'Borders' you
will
| see the edges of the cells shown in a fuzzy sort of way which indicates
| there is more than one type of border present. Click 'None' as Ian Roy
| suggests, click both the external and internal icons to the right of the
| box, OK.
| Now the dots are gone but you have no dull grey borders as you describe
them
| which are the standard gridlines in XL.
| Highlight the range again, right click, 'Format Cells' 'Patterns'
Click
| 'No Colour' This will set the range back to the status quo, in your
file.
| The cell colour in that range is white which means gridlines are not
| displayed.
| Regards,
| Alan.
| "Rodney" wrote in message
| ...
|
| G'day Alan,
| I still cannot get it.
| I select the cells, FormatCellsBorder
| select Outline and Inside.
| Select colour to Automatic
| Enter
| The cell borders lose the dots but become darker
| I cannot with any matrix get the cell borders back
| to that dull grey colour, as in the rest of the sheet.
|
|
|
| "Alan" wrote in message
| ...
| | I got the mail, it was just border formatting (Format Cells
Border)
| and
| | the cell colour set to white. I tried to mail the corrected file to
you
| but
| | it bounced back to me saying the address you used was invalid,
| | Regards,
| | Alan.
| | "Rodney" wrote in message
| | ...
| | G'day Alan,
| |
| | I'll strip the bulk of the columns, and email forthwith
| | (It's probably something really simple and obvious)
| |
| | Regards
| |
| |
| |
| |
| | "Alan" wrote in message
| | ...
| | | Looked at you example. Please send me the file (if you want to)
I'm
| | really
| | | quite curious,
| | | If you decide to do so please use
| | |
| | | Remove NOSPAM for obvious reasons,
| | | Regards,
| | | "Rodney" wrote in message
| | | ...
| | |
| | | In my sheet, I have a bunch of cells that have dotted borders,
| | | I cannot change this under format.
| | | When I add a column alongside, that part of the column offers
no
| | | gridlines at all, all is blank.
| | |
| | | How do I rectify this please, and get back to naormal cell
border
| | format?
| | |
| | | Thank you.
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| |
| |
| |
| |
|
|
|
|