Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to restore cell gridlines lost after coloring the cell in Excel?

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 04-01-2012
Member
 
Join Date: Nov 2011
Posts: 61
How to restore cell gridlines lost after coloring the cell in Excel?
  

While working on my Excel worksheet I sometimes color cells. When the cell is returned to white the gridlines for those specific cells are gone. How can I restore them?

Reply With Quote
  #2  
Old 04-01-2012
Member
 
Join Date: Nov 2010
Posts: 502
Re: How to restore cell gridlines lost after coloring the cell in Excel?

White is a color and it hides the gridlines. Highlight the cells you want to restore grid line after removing the color. On the "Home" tab, click on theme color and select "no fill" (the icon below the standard colour). Unhighlight the cells. Also you can go for None for the same purpose. it is totally dependent on you whether you wanted to use No Fill or none.
Reply With Quote
  #3  
Old 04-01-2012
Member
 
Join Date: Dec 2010
Posts: 351
Re: How to restore cell gridlines lost after coloring the cell in Excel?

In order to get the requirement of yours you have to use following steps.
  • Click on the Office button and click on Excel Option.
  • Go for Advanced into that look for Display option for worksheet and click on Show gridlines and select a new color. If you donít wanted to have any gridlines than simply uncheck Show gridlines checkbox.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to restore cell gridlines lost after coloring the cell in Excel?"
Thread Thread Starter Forum Replies Last Post
How to disable excel for taking empty cell in Excel chart Hache hi MS Office Support 2 25-02-2012 11:30 AM
Applying absolute cell referencing to many cell in Excel Nyota MS Office Support 2 24-02-2012 06:23 PM
Cell format errors appears in Excel 2003 but not in Excel 2000 @nki$achi MS Office Support 1 24-01-2012 04:00 PM
Unable to find my lost cell phone Zared Portable Devices 5 09-12-2010 06:23 AM
Auto-populate a MS Word table cell with text from a diff cell? dreamrthts Windows Software 5 23-03-2009 10:39 PM


All times are GMT +5.5. The time now is 08:47 PM.