When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.

That's how it works.

You can format the cells borders to look like grid lines.

FormatCellsBorder tab


--
Biff
Microsoft Excel MVP


"Paul" wrote in message
...
When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.

OK, thanks for that. I'll hold off on it for now, because the fill
colors are not permanent, and I have to rejig the borders after the
fill colors are removed.

T. Valko wrote:
That's how it works.

You can format the cells borders to look like grid lines.

FormatCellsBorder tab


"Paul" wrote in message
...
When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.

On Wednesday, 2 April 2008 07:22:54 UTC+9, T. Valko wrote:
That's how it works.

You can format the cells borders to look like grid lines.

FormatCellsBorder tab


--
Biff
Microsoft Excel MVP


"Paul" wrote in message
...
When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.

Thank you

One workaround...

Add cell borders to repalce the invisible gridlines. Select the block of
cells, right-click, and select Format Cells. On the Border tab of the Format
Cells dialog, select a line style. Click the Outline button, then the Inside
button, then OK.

Hope this helps,

Hutch

"Paul" wrote:

When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.

Thanks for that, Hutch. I'll hold off for now because I'd have to
undo the cell borders when the (temporary) fill color is removed.

On Apr 1, 6:24 pm, Tom Hutchins
wrote:
One workaround...

Add cell borders to repalce the invisible gridlines. Select the block of
cells, right-click, and select Format Cells. On the Border tab of the Format
Cells dialog, select a line style. Click the Outline button, then the Inside
button, then OK.

Hope this helps

"Paul" wrote:
When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.

If you apply a fill color to cells on your worksheet, you won't be able to see or print the cell gridlines for those cells. If you want to see or print the gridlines for these cells, you must remove the fill color. To do so, select the cells, and then click arrow next to Fill Color Button image (Home tab, Font group). To remove the fill color, click No Fill. Keep in mind that you must remove the fill entirely. If you simply change the fill color to white, the gridlines will remain hidden. If you want to be able to retain the fill color, you can use borders instead of gridlines. For more information, see Apply or remove cell borders on a worksheet.

On Wednesday, September 11, 2013 4:35:05 PM UTC-4, wrote:
If you apply a fill color to cells on your worksheet, you won't be able to see or print the cell gridlines for those cells. If you want to see or print the gridlines for these cells, you must remove the fill color. To do so, select the cells, and then click arrow next to Fill Color Button image (Home tab, Font group). To remove the fill color, click No Fill. Keep in mind that you must remove the fill entirely. If you simply change the fill color to white, the gridlines will remain hidden. If you want to be able to retain the fill color, you can use borders instead of gridlines. For more information, see Apply or remove cell borders on a worksheet.

If you apply the border and choose the broken line just under "none", it looks perfect when you print! It has the shading and the gridlines.

This is how you unfill on Excel. The question is how do you do this in Google Drive Sheets?

If you set the border color using the Custom Color dialog (Format-Border-Color-More Colors-Custom) to the RGB colors R:208 G:215 B:229 then it should give you the exact color as the default gridline color.

On Tuesday, April 1, 2008 6:24:00 PM UTC-4, Tom Hutchins wrote:
One workaround...

Add cell borders to repalce the invisible gridlines. Select the block of
cells, right-click, and select Format Cells. On the Border tab of the Format
Cells dialog, select a line style. Click the Outline button, then the Inside
button, then OK.

Hope this helps,

Hutch

"Paul" wrote:

When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.

On Thursday, 17 October 2013 06:15:43 UTC+13, wrote:
If you set the border color using the Custom Color dialog (Format-Border-Color-More Colors-Custom) to the RGB colors R:208 G:215 B:229 then it should give you the exact color as the default gridline color.



On Tuesday, April 1, 2008 6:24:00 PM UTC-4, Tom Hutchins wrote:

One workaround...



Add cell borders to repalce the invisible gridlines. Select the block of

cells, right-click, and select Format Cells. On the Border tab of the Format

Cells dialog, select a line style. Click the Outline button, then the Inside

button, then OK.



Hope this helps,



Hutch



"Paul" wrote:



When I apply a fill color to a block of cells, the grid lines don't

show in that block of cells. I don't expect that there is a way to

force the grid lines to show, but I'm hoping that I'm wrong. Thanks

any workarounds, if they exist.



thank you!

On Thursday, 17 October 2013 06:15:43 UTC+13, wrote:
If you set the border color using the Custom Color dialog (Format-Border-Color-More Colors-Custom) to the RGB colors R:208 G:215 B:229 then it should give you the exact color as the default gridline color.


Thank you! So helpful.

On Thursday, July 31, 2014 at 6:01:45 PM UTC-4, wrote:
On Thursday, 17 October 2013 06:15:43 UTC+13, wrote:
If you set the border color using the Custom Color dialog (Format-Border-Color-More Colors-Custom) to the RGB colors R:208 G:215 B:229 then it should give you the exact color as the default gridline color.


Thank you! So helpful.

Great fix. I have been wondering about this for years.

Awesome answer. Exactly what I needed. Thank you.

On Wednesday, 16 October 2013 18:15:43 UTC+1, wrote:
If you set the border color using the Custom Color dialog (Format-Border-Color-More Colors-Custom) to the RGB colors R:208 G:215 B:229 then it should give you the exact color as the default gridline color.

On Tuesday, April 1, 2008 6:24:00 PM UTC-4, Tom Hutchins wrote:
One workaround...

Add cell borders to repalce the invisible gridlines. Select the block of
cells, right-click, and select Format Cells. On the Border tab of the Format
Cells dialog, select a line style. Click the Outline button, then the Inside
button, then OK.

Hope this helps,

Hutch

"Paul" wrote:

When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.


In Excel 2003 there is no option for " More Colours"?

Thank you very helpful!!

On Tuesday, 1 April 2008 23:24:00 UTC+1, Tom Hutchins wrote:
One workaround...

Add cell borders to repalce the invisible gridlines. Select the block of
cells, right-click, and select Format Cells. On the Border tab of the Format
Cells dialog, select a line style. Click the Outline button, then the Inside
button, then OK.

Hope this helps,

Hutch

"Paul" wrote:

When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.


Thanks Hutch, that was very useful

Thanks for the solutions here, but it's a PITA to do this. I've noticed this since first stated using Excel in MSO 3.1 but never really sought how to do it. VERY surprised MS doesn't have a box under "FORMAT/PATTERNS/Pattern:" (with all the dots, horiz/vert/diag lines, crosshatch, diagonal crosshatch dots, etc that I've used maybe on three sheets over 25 years) that simply says GRID.

I used the solution of highlighting then border all cells with "first border under NONE" for stored/emailed spreadsheets, and will used contributor's color formula if I ever need a good printed document.

On Saturday, February 13, 2016 at 11:57:29 AM UTC-6, wrote:
Thanks for the solutions here, but it's a PITA to do this. I've noticed this since first stated using Excel in MSO 3.1 but never really sought how to fix it. VERY surprised MS doesn't have a box under "FORMAT/PATTERNS/Pattern:" (with all the dots, horiz/vert/diag lines, crosshatch, diagonal crosshatch dots, etc that I've used maybe on three sheets over 25 years) that simply says GRID.

I used the solution of highlighting then border all cells with "first border under NONE" for stored/emailed spreadsheets, and will used contributor's color formula if I ever need a good printed document.

On Saturday, February 13, 2016 at 11:57:29 AM UTC-6, wrote:
Thanks for the solutions here, but it's a PITA to do this. I've noticed this since first stated using Excel in MSO 3.1 but never really sought how to fix it. VERY surprised MS doesn't have a box under "FORMAT/PATTERNS/Pattern:" (with all the dots, horiz/vert/diag lines, crosshatch, diagonal crosshatch dots, etc that I've used maybe on three sheets over 25 years) that simply says GRID.

I used the solution of highlighting then border all cells with "first border under NONE" for stored/emailed spreadsheets, and will use contributor's color formula if I ever need a good printed document.

On Tuesday, April 1, 2008 at 4:03:51 PM UTC-6, Paul wrote:
When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.

I insert a text box sized perfectly over the cells not filled with color, then color the interior of the textbox, and set the transparency of the text box way high, so the gray gridlines underneath can show through. You have to go to Page Layout, Gridlines, and check the checkbox for Print, as you do even if you're printing uncolored cells.

On Tuesday, April 1, 2008 at 4:03:51 PM UTC-6, Paul wrote:
When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.

I am suing Excel 2010. Always showing cell border with or without fill color: Home - Styles, right click on Normal style - Modify, click on Format, Border tab, open Color combo, click on More Colors, Custom tab, enter 208, 215, 229, in RGB, click on Outline, then OK and OK. Now cell borders are always shown. Doing this in your local Normal template should available to any new book.

I am suing Excel 2010. Always showing cell border with or without fill color: Home - Styles, right click on Normal style - Modify, click on Format, Border tab, open Color combo, click on More Colors, Custom tab, enter 208, 215, 229, in RGB, click on Outline, then OK and OK. Now cell borders are always shown. Doing this in your local Normal template should available to any new book.<


Fantastic!
+100!

hoahong24k.com website cung cấp hoa hồng chất lượng nhất thị trư�ng VN.

Hoa hồng sáp hôn có ngò vÃ* hình dạng chi nhÆ° khoa thá»±c nên tốt giÃ*u phái mi râu chá»�n lá»±a công quÃ* tặng ngÃ*y 20/10.

hoả hồng sáp thơm lên ngôi

Chỉ Ä‘Æ°Æ¡ng Ä‘á»™ 1 kì cá»� nữa lÃ* đến ngÃ*y 20/10. đằng ria các mặt quán €œtruyá»�n thống€� nhÆ° mỹ phẩm, áo xống, xéo dép;€¦ năm nay thị trÆ°á»�ng há»�c quÃ* tặng Ä‘Æ°Æ¡ng xuất hiện giá»� loại món sáp khiến lắm chị em mê mẩn.

Theo chừng hiểu thứ phóng viên, sản phẩm nè Ä‘Æ°Æ¡ng phanh đòi lÃ* €œHoa hồng vÄ©nh cá»*u€� vá»›i đảng Ã*t, hÆ°Æ¡ng khóm nhẹ nhÃ*ng nhÆ° khoa thiệt. huÆ¡ giÃ*u đủ các mÃ*u sắc nhÆ° hồng, hồng, xanh, tÃ*m,€¦ cùng chồng liệu thần hồn chÃ*nh tốt đánh từ bá»� sáp cho nên thá»�i kì bảo cai quản khá lâu.

Chị Nguyá»…n thi cá»* huÆ¡ €“ má»™t ngÆ°á»�i kinh doanh danh thiếp phÆ°Æ¡ng diện hÃ*ng quÃ* cho online cho biết, sản phẩm nÃ*y má»›i xuất bây giá»� trong vụ 20/10 năm ni. Ưu chấm mức sản phẩm lÃ* nổi xuể lâu, lại thắng sầu phÆ°Æ¡ng kế chứ khác chi món tháº*t; hÆ°Æ¡ng hông nhẹ nhõm, hiệp vá»›i tuốt luốt cạc đối tịnh.

€œhuê hồng nÃ*y có xuất miá»�n tá»± HÃ*n Quốc. dù rằng má»›i giao ná»*a loại hoa nÃ* trên mạng chá»*a lâu mÃ* mình dấn đặt khá nhiá»�u má»™t để quy hÃ*ng. NgÆ°á»�i sắm cốt lÃ* danh thiếp đấng mÃ*y râu phanh chuẩn bị quÃ* biếu cho ngÃ*y 20/10. Má»—i Ä‘oá huê nhiá»�u giá nhÆ° từ 25.000 vá»›i €“ 30.000 cùng. Nếu mua theo bó, vÃ* trưởng sẽ rẻ hÆ¡n: bó 40 bông giá 800.000 cùng, bó 30 bông vÃ* 650.000 vá»›i. Vì vÃ* khoa khá cao thÃ*nh ra khách vấy cốt tá»* chỉ chuốc từ bá»� 5 €“ 10 bông. đặng tạo ra sá»± lịch thiếp, nhã, môn sẽ tốt Ä‘á»±ng trong các há»™p cứng, mÃ*u huÆ¡ vÃ* mÃ*u há»™p sẽ tÆ°Æ¡ng vá»›i€�, chị huê cho biết thêm.

ả trÆ°á»�ng quÃ* biếu 20/10: huê hồng sáp dứa Ä‘á»™c địa phẳng phiu hút khách khứa

Ä�ang Ä‘au đầu chá»�n mua quÃ* tặng tặng vợ vÃ* nạ, anh Nguyá»…n que Tùng (lô Ä�a, HÃ* Ná»™i) khá vui mừng bởi vì phanh bạn bè giá»›i thiệu Hoa hồng sáp khóm. NgÃ*y 20/10 năm nÃ* cÅ©ng tặng Hoa hồng năng mua mỹ phẩm, xống áo; đừng lắm hệt má»›i. Năm nay nhiá»�u loại huê nÃ*o bởi thế anh không nếu nhÆ° mất thá»�i kì nghÄ© tÃ*nh tình do váº*y chuốc quÃ* gì nữa.

€œtừng hiểu trên mệnh tá»› nhằm biết loại khoa nÃ*y lắm trạng thái lÆ°u giữ đặng ngò thÆ¡m trÆ°á»�ng Ä‘oản cú 2 €“ 3 năm. MÃ*u dung nhan huê cÅ©ng Ä‘áº*m vÃ* búng báng hÆ¡n so đồng hoa thiệt. HÆ¡n nữa, sản phẩm nÃ*o giÃ*u có mÃ*u thÃ*nh ra trui mặc sức lá»±a chá»�n. mình dá»± tÃ*nh chuốc 2 bó. Bó mÃ*u tÃ*m biếu tặng bầm vÃ* bó mÃ*u Ä‘á»� tặng cho vợ. Ä�ây lÃ* những mÃ*u trưởng 2 yêu thÃ*ch thú. cả năm gia tá»™c nhỉ vất vả lo cho gia ách, đây lÃ* dịp tá»� tÆ°á»�ng dạ hÃ*m Æ¡n nên quÃ* chẳng thể sÆ¡ lược đặng€�, anh Tùng san sẻ.

Tung chiêu khuyến mãi da dạng tốt tăng lực chuốc

CÃ*ng xáp ngÃ*y nữ giá»›i Việt Nam (20/10), thị dÃ*i quÃ* tặng lại cÃ*ng sôi há»…. nhiá»�u cá»*a dãy Ä‘Æ°a vÃ*o hình thức khuyến mại hấp dẫn phanh vấn ngÆ°á»�i chuốc. Bên rìa khuÆ¡ búng báng, các phÆ°Æ¡ng diện dÃ*nh lÃ*u nhÆ° mỹ phẩm, áo quần, chéo dép,€¦ cÅ©ng lÃ* những sản phẩm hút khách.

Tại Ä‘Æ¡n số tuyến Ä‘Æ°á»�ng siêng bán áo quần, mỹ phẩm nhÆ° Xuân Thủy (Cầu Giấy); Chùa Bá»™c, Phạm Ngá»�c Thạch (lô da),€¦ dÃ*nh xê ri cá»*a quán quÃ* cho Ä‘ua rau giảm giá. má»—i má»™t nÆ¡i lại tiá»…n chân vÃ*o Ä‘Æ¡n hình thức khuyến mại riêng nhÆ° chuốc 1 biếu 1, giảm vÃ* trÆ°á»�ng Ä‘oản cú 10 €“ 50% tặng tất bình diện dây, miá»…n uổng giao đầu hÃ*ng€¦

Chị thu Trang €“ chủ má»™t cá»*a quy hÃ*ng quần áo trên lối Xuân Thủy (Cầu Giấy) tặng biết, vÃ*i năm cáº*n đây, nhiá»�u chị em lắm xu hÆ°á»›ng đầu đông tầng mua dÃ*nh dáng giảm giá nhÆ° vụ vỉa hè vÃ* ngược lại. €œTâm lý cụm từ ngÆ°á»�i chuốc thẳng tắp xăm dÃ*nh lÃ*u hóa chất lượng, rẻ song nếu xinh xẻo. thÃ*nh ra, dÃ*nh dáng năm cứ tá»›i ngÃ*y 8/3 vÃ* 20/10 cÅ©ng lÃ* thá»�i Ä‘iểm trao vụ, cá»*a quán mình lại nhiá»�u đợt xả dÃ*nh dáng tốt nháº*p tuồng má»›i phai ná»*a. má»—i má»™t dịp nhÆ° cầm cố, lượng khách khứa ghé thăm vÃ* chuốc hÃ*ng vá»™i vÃ*ng 3 €“ 5 báº*n so đồng những thá»�i khắc khác trong suốt năm€�, chị Trang san sá»›t thêm.

Tại má»™t cá»*a dây chéo, dép trên Ä‘Ã*ng Cầu Giấy (Cầu Giấy) rã ra dây loạt khuyến mại nhÆ° chuốc 2 cho 1, giảm vÃ* 20% vá»›i má»™t mệnh mẫu ta giÃ*y dÃ*nh cho mùa đông. Anh quang đãng €“ chủ cá»*a đầu hÃ*ng tặng biết, thắng tăng sức mua vÃ* thu buổi cá»±u nên anh tiá»…n vÃ*o các hình thức khuyến mại nÃ*o lÃ* nổi kÃ*ch cầu.

€œthá»�i kì cáº*n đây, lá»±c cạnh giáº*t cao, dÃ*nh hóa ăn tiêu thụ muá»™n bởi thế danh thiếp ngÃ*y lỡi lÃ* nhịp đặng suýt khách dÃ*nh dáng. Má»›i treo bể xuể hai hôm cÆ¡ mÃ* cây khách khứa đến mua đặt cải thiện đáng thuáº*t. Hy vá»�ng tá»± bây chừ tặng đến 20/10, mệnh cây ngÆ°á»�i chuốc sẽ đông hÆ¡n nữa€�, anh quang đãng vui mừng vẻ san sẻ.

On Tuesday, April 1, 2008 at 3:03:51 PM UTC-7, Paul wrote:
When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.

This is what I use because I want colors but still wanted the faint gridline to organize the data.

My solution: Highlight the area you want the gridlines (likely the area you colored and lost them) - Right click - format cells - select the normal border size on the bottom left of the style box - under the color option select "Tan, Background 2" (this is a pre-set option third over right on the top selection - next ensure you select the type of border you want (this is the sample box that says "none, outline, inside, etc.) - finally click okay. You should now have a faint grid border that blends with the original grid marks un-noticingly (yes I made that word up :)

You can then use the same steps to add a black border around your new grid like border to better present your colored grid lined chart. :)

Yes, there is a way to force the grid lines to show even when there is a fill color applied to a block of cells. Here's how you can do it:

1. Select the block of cells where you have applied the fill color.
2. Go to the Home tab in the ribbon at the top of the Excel window.
3. Click on the Format button in the Cells group.
4. In the dropdown menu, select Format Cells.
5. In the Format Cells dialog box, go to the Border tab.
6. Under Presets, select the type of border you want to apply to the cells. For example, you can select All Borders to apply a border around all sides of the cells.
7. Click on the Color dropdown menu to select the color of the border.
8. Click on the OK button to apply the border to the cells.

By applying a border to the cells, you can force the grid lines to show even when there is a fill color applied to the cells. This workaround will help you to maintain the visibility of the grid lines in your Excel worksheet.