Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Some gridlines are not visible in Excel
I have received an Excel workbook - most gridlines are visible, but some of
these not. Any ideas about the cause and how to turn all gridlines visible? Many thanks, Koen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Some gridlines are not visible in Excel
Go to Tools-Options-View and make sure Gridlines is checked. If it is
already checked, ensure the color is set to black or dark gray. "Koen" wrote: I have received an Excel workbook - most gridlines are visible, but some of these not. Any ideas about the cause and how to turn all gridlines visible? Many thanks, Koen |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Some gridlines are not visible in Excel
If just some cells, probably due to the background color of those cells being
set to White. The background color wipes out the gridlines. Set to "Automatic" to see gridlines. Gord Dibben MS Excel MVP On Thu, 21 Jun 2007 08:24:02 -0700, Koen wrote: I have received an Excel workbook - most gridlines are visible, but some of these not. Any ideas about the cause and how to turn all gridlines visible? Many thanks, Koen |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Some gridlines are not visible in Excel
Indeed: I've selected all cells and went to Format, Cells, Patterns and
changed the cell shading color from white to No Color. This solved the issue. Many thanks to both of your for your feedback, Koen "Gord Dibben" wrote: If just some cells, probably due to the background color of those cells being set to White. The background color wipes out the gridlines. Set to "Automatic" to see gridlines. Gord Dibben MS Excel MVP On Thu, 21 Jun 2007 08:24:02 -0700, Koen wrote: I have received an Excel workbook - most gridlines are visible, but some of these not. Any ideas about the cause and how to turn all gridlines visible? Many thanks, Koen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row colors overlay the gridlines...how do I show gridlines? | Excel Discussion (Misc queries) | |||
In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- | New Users to Excel | |||
White gridlines that visible over columns? | Charts and Charting in Excel | |||
Gridlines in excel | Excel Discussion (Misc queries) | |||
Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) |