ExcelBanter - Strange border format.

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Strange border format. (https://www.excelbanter.com/new-users-excel/25227-strange-border-format.html)

Rodney

Strange border format.

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.

Debra Dalgleish

Maybe you're seeing page break marks. To turn them off, choose
ToolsOptions.
On the View tab, remove the check mark from Page Breaks.
Click OK

Rodney wrote:
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.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

CLR

Could be you're seeing the leftovers from a partially deleted drawing
object, etc........try moving the cursor slowly over the "border" and if it
changes shape, Right-click and CUT..........you may have to do this several
times............

Vaya con Dios,
Chuck, CABGx3

"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.

Rodney

Thankyou Debra and CLR,
lucked out, not pagebreaks, cursor does not change.

Here is an image of the part sheet,
dotted lines are in the differential and mean columns.
http://cjoint.com/data/fhvFIi2wOZ.htm

Thankyou for your time thus far.

| Maybe you're seeing page break marks. To turn them off, choose
| ToolsOptions.
| On the View tab, remove the check mark from Page Breaks.
| Click OK
|
| Rodney wrote:
| 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.
|
|
|
|
|
|
|
| --
| Debra Dalgleish
| Excel FAQ, Tips & Book List
| http://www.contextures.com/tiptech.html
|

Jimbola

Could it be some sort of conditional formatting.
Check this by clicking

Format Conditional Formatting

and see if any rules have been applied, if so you can click the delete rule
select the rules and then delete them

"Rodney" wrote:

Thankyou Debra and CLR,
lucked out, not pagebreaks, cursor does not change.

Here is an image of the part sheet,
dotted lines are in the differential and mean columns.
http://cjoint.com/data/fhvFIi2wOZ.htm

Thankyou for your time thus far.

| Maybe you're seeing page break marks. To turn them off, choose
| ToolsOptions.
| On the View tab, remove the check mark from Page Breaks.
| Click OK
|
| Rodney wrote:
| 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.
|
|
|
|
|
|
|
| --
| Debra Dalgleish
| Excel FAQ, Tips & Book List
| http://www.contextures.com/tiptech.html
|

CLR

Try File PrintArea ClearPrintArea

Vaya con Dios,
Chuck, CABGx3

"Rodney" wrote in message
...

Thankyou Debra and CLR,
lucked out, not pagebreaks, cursor does not change.

Here is an image of the part sheet,
dotted lines are in the differential and mean columns.
http://cjoint.com/data/fhvFIi2wOZ.htm

Thankyou for your time thus far.

| Maybe you're seeing page break marks. To turn them off, choose
| ToolsOptions.
| On the View tab, remove the check mark from Page Breaks.
| Click OK
|
| Rodney wrote:
| 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.
|
|
|
|
|
|
|
| --
| Debra Dalgleish
| Excel FAQ, Tips & Book List
| http://www.contextures.com/tiptech.html
|

Rodney

Thanks Jimbola and CLR,

It is not "Print Area"
It is not "Conditional Formatting"

Would it perhaps be some sort of "Array" I have accidentally
invoked?

I shall be offline for the next 10 hours,
football commitments.

Thankyou for your time.

| Could it be some sort of conditional formatting.
| Check this by clicking
|
| Format Conditional Formatting
|
| and see if any rules have been applied, if so you can click the delete rule
| select the rules and then delete them
|
|
| "Rodney" wrote:
|
|
|
| Thankyou Debra and CLR,
| lucked out, not pagebreaks, cursor does not change.
|
| Here is an image of the part sheet,
| dotted lines are in the differential and mean columns.
| http://cjoint.com/data/fhvFIi2wOZ.htm
|
| Thankyou for your time thus far.
|
|
|
| | Maybe you're seeing page break marks. To turn them off, choose
| | ToolsOptions.
| | On the View tab, remove the check mark from Page Breaks.
| | Click OK
| |
| | Rodney wrote:
| | 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.
| |
| |
| |
| |
| |
| |
| |
| | --
| | Debra Dalgleish
| | Excel FAQ, Tips & Book List
| | http://www.contextures.com/tiptech.html
| |
|
|
|

Rodney

Alan

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.

Rodney

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.
|
|
|
|
|
|
|

Alan

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.
|
|
|
|
|
|
|

Rodney

IanRoy

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.

Alan

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.
| |
| |
| |
| |
| |
| |
| |
|
|
|
|

Rodney

IanRoy

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.
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| |
| |
| |
| |
|
|
|
|

Alan

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.
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| |
| |
| |
| |
|
|
|
|

All times are GMT +1. The time now is 01:51 PM.