#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Gridlines disappear

I copied cells from a web page into Excel (2007). This worked fine. Now I
want to remove the border lines. I went into format cells, then border. I
tried selecting NONE under presets and also tried manually removing all of
the borders individually-both with same results. When I am done there are
now no lines around those cells, not only no borders but also no gridlines.
I verified under View that gridlines is checked. I also checked Page Layout
and view gridlines is also checked there. I tried unchecking and then
checking again but the gridlines never appear around the cells that I removed
the borders from. I can add the borders back, but when I remove them I now
have no gridlines again.

I would really like to have the gridlines around those cells. Can anyone
help?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default Gridlines disappear

Select the cell that have the MIA gridlines and do the following:

Click FORMAT on the menu and select Cells

Click the PATTERNS and choose no Color
--
Kevin Backmann


"stucker" wrote:

I copied cells from a web page into Excel (2007). This worked fine. Now I
want to remove the border lines. I went into format cells, then border. I
tried selecting NONE under presets and also tried manually removing all of
the borders individually-both with same results. When I am done there are
now no lines around those cells, not only no borders but also no gridlines.
I verified under View that gridlines is checked. I also checked Page Layout
and view gridlines is also checked there. I tried unchecking and then
checking again but the gridlines never appear around the cells that I removed
the borders from. I can add the borders back, but when I remove them I now
have no gridlines again.

I would really like to have the gridlines around those cells. Can anyone
help?

Thanks

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 disappear when I use color fill Lynninstitches Excel Discussion (Misc queries) 6 May 4th 07 02:38 AM
Gridlines disappear when using "Fill" Sherry Excel Discussion (Misc queries) 3 October 19th 06 08:23 PM
In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- 4most New Users to Excel 3 July 9th 06 01:45 AM
Why do gridlines disappear from view when highlighted bjrules Excel Worksheet Functions 3 March 1st 06 04:38 PM
Excel gridlines disappear when color is added nelson1344 Excel Discussion (Misc queries) 2 March 15th 05 12:37 AM


All times are GMT +1. The time now is 04:01 PM.

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

About Us

"It's about Microsoft Excel"