Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 11th 08, 05:57 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 4
Default some missing gridlines

I've been fooling around with the new version of Excel. While I was checking
my data I had some lines highlighted and some lines with different coloured
fonts. Once I had finished checking, I selected all and removed the
highlights and font colours so everything looks uniform (no highlights, all
black font). However, the background gridlines have disappeared from some
cells (but not all cells).

I went through Excel Options Advanced checked gridlines.

In the Show/Hide box on the ribbon (?), gridlines is also ticked.

Why are some of the gridlines missing?

How can I get them back?!?!?

Thanks,

buggirl

  #2   Report Post  
Old March 11th 08, 06:19 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 2,819
Default some missing gridlines

If you set the cell background or pattern to "white" instead of "no
color" this will cover up the grid lines.

buggirl wrote:

I've been fooling around with the new version of Excel. While I was checking
my data I had some lines highlighted and some lines with different coloured
fonts. Once I had finished checking, I selected all and removed the
highlights and font colours so everything looks uniform (no highlights, all
black font). However, the background gridlines have disappeared from some
cells (but not all cells).

I went through Excel Options Advanced checked gridlines.

In the Show/Hide box on the ribbon (?), gridlines is also ticked.

Why are some of the gridlines missing?

How can I get them back?!?!?

Thanks,

buggirl


  #3   Report Post  
Old March 11th 08, 06:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 4
Default some missing gridlines

Thank you! A simple answer - wonderful!

"Bob I" wrote:

If you set the cell background or pattern to "white" instead of "no
color" this will cover up the grid lines.

buggirl wrote:

I've been fooling around with the new version of Excel. While I was checking
my data I had some lines highlighted and some lines with different coloured
fonts. Once I had finished checking, I selected all and removed the
highlights and font colours so everything looks uniform (no highlights, all
black font). However, the background gridlines have disappeared from some
cells (but not all cells).

I went through Excel Options Advanced checked gridlines.

In the Show/Hide box on the ribbon (?), gridlines is also ticked.

Why are some of the gridlines missing?

How can I get them back?!?!?

Thanks,

buggirl



  #4   Report Post  
Old March 11th 08, 06:41 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 2,819
Default some missing gridlines

You're welcome, have a great day!

buggirl wrote:
Thank you! A simple answer - wonderful!

"Bob I" wrote:


If you set the cell background or pattern to "white" instead of "no
color" this will cover up the grid lines.

buggirl wrote:


I've been fooling around with the new version of Excel. While I was checking
my data I had some lines highlighted and some lines with different coloured
fonts. Once I had finished checking, I selected all and removed the
highlights and font colours so everything looks uniform (no highlights, all
black font). However, the background gridlines have disappeared from some
cells (but not all cells).

I went through Excel Options Advanced checked gridlines.

In the Show/Hide box on the ribbon (?), gridlines is also ticked.

Why are some of the gridlines missing?

How can I get them back?!?!?

Thanks,

buggirl




  #5   Report Post  
Old July 14th 12, 09:44 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 1
Default some missing gridlines

On Tuesday, March 11, 2008 1:41:51 PM UTC-4, Bob I wrote:
You're welcome, have a great day!

buggirl wrote:
> Thank you! A simple answer - wonderful!
>
> "Bob I" wrote:
>
>
>>If you set the cell background or pattern to "white" instead of "no
>>color" this will cover up the grid lines.
>>
>>buggirl wrote:
>>
>>
>>>I've been fooling around with the new version of Excel. While I was checking
>>>my data I had some lines highlighted and some lines with different coloured
>>>fonts. Once I had finished checking, I selected all and removed the
>>>highlights and font colours so everything looks uniform (no highlights, all
>>>black font). However, the background gridlines have disappeared from some
>>>cells (but not all cells).
>>>
>>>I went through Excel Options > Advanced > checked gridlines.
>>>
>>>In the Show/Hide box on the ribbon (?), gridlines is also ticked.
>>>
>>>Why are some of the gridlines missing?
>>>
>>>How can I get them back?!?!?
>>>
>>>Thanks,
>>>
>>>buggirl
>>
>>


THANK YOU! I HAD THE SAME PROBLEM AND TRIED THINGS ON MY OWN WITH NO SUCCESS. YOUR TIP WORKED IN 1 SECOND! JAN


  #6   Report Post  
Old January 29th 15, 08:01 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2015
Posts: 1
Default some missing gridlines

Hi!!
My Grid lines appear and disappear when I scroll up and down. I downloaded it to excel and some lines are gone and some aren't. Do you have any other tips for me? I went through all the boxes and reset the color so none are white.
  #7   Report Post  
Old November 14th 17, 10:53 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2017
Posts: 1
Default some missing gridlines

some grid lines not showing in excel no problem see the video and know how to solve this.

https://www.youtube.com/watch?v=qqFlcUWXMVE


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gridlines Are Missing. Purrlgirl Excel Discussion (Misc queries) 6 January 2nd 08 11:45 PM
gridlines missing in web version Magster Excel Discussion (Misc queries) 1 August 22nd 07 11:12 PM
Gridlines missing after Paste JMay Excel Discussion (Misc queries) 2 August 7th 07 02:28 PM
In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- 4most New Users to Excel 3 July 9th 06 01:45 AM
where are my missing gridlines newbie Excel Discussion (Misc queries) 2 August 4th 05 06:50 PM


All times are GMT +1. The time now is 02:50 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017