If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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. | | | | | | | |
#12
|
|||
|
|||
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. | | | | | | | | | | | | | | | | | | |
#13
|
|||
|
|||
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. |
#14
|
|||
|
|||
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. | | | | | | | | | | | | | | | | | | |
#15
|
|||
|
|||
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. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
#16
|
|||
|
|||
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. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
#17
|
|||
|
|||
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. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
custom number format | cac | General Discussion | 1 | January 24th, 2005 05:49 PM |
Forcing Outlook to reply to HTML emails using plain text format | none | General Discussion | 1 | January 18th, 2005 11:29 PM |
Find/Replace text, NOT format!!! | HennyBogan | General Discussion | 5 | June 21st, 2004 08:45 PM |
Any way of forcing Plain Text Format universally? | Astra | General Discussions | 0 | June 4th, 2004 09:34 AM |