Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Remove borders, keep grid-lines
I am using Excel 2008 on a Mac desktop computer with OS 10.8.5.
I added a border to a certain row of cells (a black line underneath the row) in a spreadsheet, and saved the spreadsheet. Now I want to remove that border, but when I do that, the grid-line corresponding to it disappears, too. Using the standard procedure for making grid-lines visible does not restore it. I should be grateful for advice as to how to solve this conundrum. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove borders, keep grid-lines
Hi Micheal,
Am Wed, 28 Oct 2015 11:48:22 +0000 schrieb Michael Graubart: I added a border to a certain row of cells (a black line underneath the row) in a spreadsheet, and saved the spreadsheet. Now I want to remove that border, but when I do that, the grid-line corresponding to it disappears, too. do you have white back color in this cell? Change it to no back color. Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#3
|
|||
|
|||
Quote:
I don't know how it is that I did not receive notification that you replied to my question, but I have only just found your reply. I apologize. I'm not quite sure whether 'back color' is the same as 'Fill', but in the Fill dialog, all the cells in my spreadsheets are set to 'No Fill' — and despite that, the grid line disappears if I select the 'no border' option. The curious thing is that if I try this in a new, blank worksheet, it behaves just as you suggest; but in my existing worksheets it doesn't. Have you, or anyone else, any explanation of this phenomenon? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel- printing borders (not grid lines) | Excel Discussion (Misc queries) | |||
Printing with grid lines or borders - problem | Excel Discussion (Misc queries) | |||
Grid lines in Excel not showing.Have tools,options,view/grid cked | Excel Discussion (Misc queries) | |||
printing grid lines when grid lines is checked | Setting up and Configuration of Excel | |||
Grid Lines vs. Borders | Excel Programming |