How do I shade cells in Excel and keep gridlines?
Click File > Excel > Options. In the Advanced category, under Display options for this worksheet, make sure that the Show gridlines check box is selected. In the Gridline color box, click the color you want. Tip: To return gridlines to the default color, click Automatic.
How do I get the GREY gridlines back in Excel?
- Select the worksheet.
- Click the Page Layout tab.
- To show gridlines: Under Gridlines, select the View check box. To hide gridlines: Under Gridlines, clear the View check box.
How do I make lines visible in Excel when printing?
This article describes how you can make the gridlines appear in your printed worksheets.
- Select the worksheet or worksheets that you want to print.
- On the Page Layout tab, in the Sheet Options group, select the Print check box under Gridlines.
- Click the File tab, and then click Print.
- Click the Print button.
How do you fill a cell without losing gridlines?
Select the cells that are missing the gridlines, or hit Control + A to select the entire worksheet. Then, under the Home tab in the Font group change the color of the cells by clicking on the little arrow to the right of the can of spilling paint and choosing no fill.
Why are some gridlines missing in Excel?
If the background color for a cell is white instead of no fill, then it will appear that the gridlines are missing. Select the cells that are missing the gridlines, or hit Control + A to select the entire worksheet.
Why won’t my gridlines print in Excel?
If gridlines don’t appear in the print preview or the resulting printout, you probably have the “Draft quality” enabled for your printer. This mode is designed to save ink, so it omits things like the gridlines. To disable this option, click File > Print > Page Setup in Excel. Click the “Sheet” tab.