How to keep gridlines in Excel when fill color

Easy bullets in Excel

Click here to reveal answer

If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Sep 12, 2013, 5:35:05 AM9/12/13



Sign in to reply to author

Sign in to forward

You do not have permission to delete messages in this group

Sign in to report message as abuse

Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message

to

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.