Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Remove Pattern Without Affecting Cell Color or Gridlines

How can I remove a cell pattern without affecting the cell color or gridlines?

Here is what happened. I have a spreadsheet that is 100x100 cells. The
cells had various colors applied using the Format Cells/Patterns/Cell Shading
dialog. I temporarily wanted to flag these cells as DO NOT EDIT by adding a
pattern (light dots) using the Format Cells/Patterns/Pattern dialog. I went
back to remove the pattern using the same dialog, but the gridlines are no
longer visible. I looked in MS Help - they suggest clicking on the Fill tool
and selecting NO FILL. When I do this, the gridlines come back, but the cell
coloring is now gone. Is there a way to remove the pattern while preserving
the grid and original cell coloring? Thanks so much.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Remove Pattern Without Affecting Cell Color or Gridlines

  1. Select the cells that have the pattern you want to remove.
  2. Right-click on the selection and choose Format Cells from the context menu.
  3. In the Format Cells dialog box, click on the Fill tab.
  4. Under the Fill tab, select the No Fill option.
  5. Click OK to close the dialog box.

This will remove the pattern from the selected cells without affecting the cell color or gridlines. The gridlines should still be visible, and the original cell coloring should remain intact.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default Remove Pattern Without Affecting Cell Color or Gridlines

Hi,

When you have a fill color on a cell the gridlines are no longer visible.
The solution is to add Borders. Choose a light gray dotted border and match
it to the gridlines and it will probably look ok.

--
Cheers,
Shane Devenshire


"Filibuster" wrote:

How can I remove a cell pattern without affecting the cell color or gridlines?

Here is what happened. I have a spreadsheet that is 100x100 cells. The
cells had various colors applied using the Format Cells/Patterns/Cell Shading
dialog. I temporarily wanted to flag these cells as DO NOT EDIT by adding a
pattern (light dots) using the Format Cells/Patterns/Pattern dialog. I went
back to remove the pattern using the same dialog, but the gridlines are no
longer visible. I looked in MS Help - they suggest clicking on the Fill tool
and selecting NO FILL. When I do this, the gridlines come back, but the cell
coloring is now gone. Is there a way to remove the pattern while preserving
the grid and original cell coloring? Thanks so much.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 284
Default Remove Pattern Without Affecting Cell Color or Gridlines

Filibuster

Select the range that you have cells within to fix. Go back to format
Cell/patterns/cell shading and select the one that has no pattern. (upper
left in xl2k) Ok out and it should have cleared all patterns and everything
else should be as it was.

Mike Rogers

"Filibuster" wrote:

How can I remove a cell pattern without affecting the cell color or gridlines?

Here is what happened. I have a spreadsheet that is 100x100 cells. The
cells had various colors applied using the Format Cells/Patterns/Cell Shading
dialog. I temporarily wanted to flag these cells as DO NOT EDIT by adding a
pattern (light dots) using the Format Cells/Patterns/Pattern dialog. I went
back to remove the pattern using the same dialog, but the gridlines are no
longer visible. I looked in MS Help - they suggest clicking on the Fill tool
and selecting NO FILL. When I do this, the gridlines come back, but the cell
coloring is now gone. Is there a way to remove the pattern while preserving
the grid and original cell coloring? Thanks so much.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default Remove Pattern Without Affecting Cell Color or Gridlines

In Excel 2007 if you fill the cell with anything but pattern color, you can
remove the pattern by selecting the pattern style at the top left of the
selections and the fill color will remain. However, if you used Pattern
color to fill the cell, the patter color will be removed also. I don't think
previous versions of Excel had pattern color in the Fill tab in Format
Cells.

Tyro


"Filibuster" wrote in message
...
How can I remove a cell pattern without affecting the cell color or
gridlines?

Here is what happened. I have a spreadsheet that is 100x100 cells. The
cells had various colors applied using the Format Cells/Patterns/Cell
Shading
dialog. I temporarily wanted to flag these cells as DO NOT EDIT by adding
a
pattern (light dots) using the Format Cells/Patterns/Pattern dialog. I
went
back to remove the pattern using the same dialog, but the gridlines are no
longer visible. I looked in MS Help - they suggest clicking on the Fill
tool
and selecting NO FILL. When I do this, the gridlines come back, but the
cell
coloring is now gone. Is there a way to remove the pattern while
preserving
the grid and original cell coloring? Thanks so much.





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default Remove Pattern Without Affecting Cell Color or Gridlines

Hi Tyro,

Earlier versions do have a pattern drop-down on the Patterns tab just like
2007, only difference in 2007 is you can use gradient fills and there are
about 16 million colors to choose from instead of 56.
--
Thanks,
Shane Devenshire


"Tyro" wrote:

In Excel 2007 if you fill the cell with anything but pattern color, you can
remove the pattern by selecting the pattern style at the top left of the
selections and the fill color will remain. However, if you used Pattern
color to fill the cell, the patter color will be removed also. I don't think
previous versions of Excel had pattern color in the Fill tab in Format
Cells.

Tyro


"Filibuster" wrote in message
...
How can I remove a cell pattern without affecting the cell color or
gridlines?

Here is what happened. I have a spreadsheet that is 100x100 cells. The
cells had various colors applied using the Format Cells/Patterns/Cell
Shading
dialog. I temporarily wanted to flag these cells as DO NOT EDIT by adding
a
pattern (light dots) using the Format Cells/Patterns/Pattern dialog. I
went
back to remove the pattern using the same dialog, but the gridlines are no
longer visible. I looked in MS Help - they suggest clicking on the Fill
tool
and selecting NO FILL. When I do this, the gridlines come back, but the
cell
coloring is now gone. Is there a way to remove the pattern while
preserving
the grid and original cell coloring? Thanks so much.




  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Remove Pattern Without Affecting Cell Color or Gridlines

Hi All,

Thanks for the replies - but I am still having problems. I should also
mention, the original spreadsheet used borders extensively, and adding lite
gray borders to simulate the gridlines will destroy them.

To see what I am talking about, try this. Open a blank work sheet.
Highlight a square block of cells. Format Cells... Patterns and click a
color OK. Then, highlight a larger square area that includes the colored
cells. Format Cells... Patterns and click a pattern OK. Now, highlight all
the same cells from step 2 and remove the pattern. You'll see the gridlines
are no longer visible.

I think the problem is that when removing the pattern, I want the checkbox
to show greyed out (like it is originally before you select pattern) instead
of picking the empty white "pattern".

Maybe I can do this through VBA.
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Remove Pattern Without Affecting Cell Color or Gridlines

I played with this a little more. If your selected range (with pattern)
includes cells with color, and cells without color - then your remove the
pattern - excel adds white as the cell color for cells that were originally
not colored. By adding the white cell color - the gridlines go away. Any
ideas how I can keep the colorless cells colorless? Maybe I need to write
some code...

"Filibuster" wrote:

How can I remove a cell pattern without affecting the cell color or gridlines?

Here is what happened. I have a spreadsheet that is 100x100 cells. The
cells had various colors applied using the Format Cells/Patterns/Cell Shading
dialog. I temporarily wanted to flag these cells as DO NOT EDIT by adding a
pattern (light dots) using the Format Cells/Patterns/Pattern dialog. I went
back to remove the pattern using the same dialog, but the gridlines are no
longer visible. I looked in MS Help - they suggest clicking on the Fill tool
and selecting NO FILL. When I do this, the gridlines come back, but the cell
coloring is now gone. Is there a way to remove the pattern while preserving
the grid and original cell coloring? Thanks so much.

  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default Remove Pattern Without Affecting Cell Color or Gridlines

I use Excel 2007. I selected 4 cells then formatted Pattern Color then
Pattern Style (any but uppermost left style). Then I selected 16 cells
including the previous 4 and formatted Pattern Color and Pattern Style (any
but uppermost left style). I cannot get a pattern to appear without
selecting a pattern style. Then went to Format Cells - Fill and selected
Background Color - No color. The pattern colors and styles disappeared and
the gridlines remained. I can make the gridlines disappear by selecting the
upper left selection in Pattern Styles and bring the gridlines back by
selecting Background Color - No color. The uppermost left pattern style
hides the gridlines but does not apply a color.

tyro

"Filibuster" wrote in message
...
Hi All,

Thanks for the replies - but I am still having problems. I should also
mention, the original spreadsheet used borders extensively, and adding
lite
gray borders to simulate the gridlines will destroy them.

To see what I am talking about, try this. Open a blank work sheet.
Highlight a square block of cells. Format Cells... Patterns and click a
color OK. Then, highlight a larger square area that includes the colored
cells. Format Cells... Patterns and click a pattern OK. Now, highlight
all
the same cells from step 2 and remove the pattern. You'll see the
gridlines
are no longer visible.

I think the problem is that when removing the pattern, I want the checkbox
to show greyed out (like it is originally before you select pattern)
instead
of picking the empty white "pattern".

Maybe I can do this through VBA.



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
Cell pattern/color laughing Excel Discussion (Misc queries) 2 December 3rd 07 04:57 PM
Cell color pattern styles in Excel 2007 Candida Excel Discussion (Misc queries) 7 June 18th 07 04:52 PM
cell pattern - color tikchye_oldLearner57 Excel Discussion (Misc queries) 2 April 11th 07 12:28 PM
Date sensitive cell pattern color Darrell Shuman Excel Worksheet Functions 4 August 17th 06 04:26 PM
How do I change color pattern based upon a formula within a cell? aemuk Excel Worksheet Functions 1 June 16th 06 11:18 PM


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

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

About Us

"It's about Microsoft Excel"