ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   where are my missing gridlines (https://www.excelbanter.com/excel-discussion-misc-queries/38728-where-my-missing-gridlines.html)

newbie

where are my missing gridlines
 
Even though I have gridlines checkes on the vew tab under tools and options
it seems there are spots where there are no gridlines. Help! I want a nice
clean look in my work. Thanks!

Jim Rech

Gridlines sometimes seem to be gone when they are given a white color. Pick
a cell with no apparent border and then do a Format, Cells, Border and then
click None and OK. If that works you can select an entire range and do the
same thing.

--
Jim
"newbie" wrote in message
...
| Even though I have gridlines checkes on the vew tab under tools and
options
| it seems there are spots where there are no gridlines. Help! I want a nice
| clean look in my work. Thanks!



Debra Dalgleish

The gridlines disappear if cells are filled with any colour, including
white.

Choose No Fill and the gridlines may reappear.

newbie wrote:
Even though I have gridlines checkes on the vew tab under tools and options
it seems there are spots where there are no gridlines. Help! I want a nice
clean look in my work. Thanks!



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



All times are GMT +1. The time now is 08:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com