Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel: Remove color background from cells, restore grid.

1) I select cells and add a background color, say yellow.
2) I later want to remove the background color from a few of the colored
cells.
3) The background changes to white BUT the gray grid lines that surrounded
the cells have vanished.
4) I try adding a border but it looks different.

How do I restore the original cell grid lines to the worksheet?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Excel: Remove color background from cells, restore grid.

Hi tolstoi

Choose "No Fill" instead of White in the Fill Color dialog

--
Regards Ron de Bruin
http://www.rondebruin.nl


"tolstoi" wrote in message ...
1) I select cells and add a background color, say yellow.
2) I later want to remove the background color from a few of the colored
cells.
3) The background changes to white BUT the gray grid lines that surrounded
the cells have vanished.
4) I try adding a border but it looks different.

How do I restore the original cell grid lines to the worksheet?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,290
Default Excel: Remove color background from cells, restore grid.

A cell interior color overrides the gridlines surrounding the cell.
Therefore, the common border (gridline) for an adjacent uncolored cell will not show.
You can come close to duplicating the appearance of a gridline by using a
thin solid border with a light gray color.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"tolstoi"
wrote in message
1) I select cells and add a background color, say yellow.
2) I later want to remove the background color from a few of the colored
cells.
3) The background changes to white BUT the gray grid lines that surrounded
the cells have vanished.
4) I try adding a border but it looks different.

How do I restore the original cell grid lines to the worksheet?
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
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
Rotating excel spreadsheet for use in photoshop/ using diamond cells tia sal2 [email protected] Excel Discussion (Misc queries) 3 October 22nd 06 02:48 AM
Excel truncated my cells when copying, how to avoid?? bxc2739 Excel Discussion (Misc queries) 0 March 17th 06 04:40 PM
Maintain proper links when Excel cells are moved Excelnovice Excel Discussion (Misc queries) 0 February 19th 06 06:17 PM
How can I remove hidden empty text cells from Excel? Bill Z1P Excel Worksheet Functions 2 October 2nd 05 08:04 PM


All times are GMT +1. The time now is 12:20 AM.

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

About Us

"It's about Microsoft Excel"