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.

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

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.

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
|

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
|

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
|

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

Just before I sign off, a thought.
I regularly paste and cut, to and from Excel's sibling MSWorks.
May I have pasted some sort of non regulation format over from Works?
Thanks.



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

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