If the issue is that you can see gridlines on your worksheet but aren’t seeing them on printed pages, you can just enable gridlines when printing. Skip to Step 8 to learn how. If you see gridlines on the page but want to add more obvious borders around certain cells or ranges, see Adding Cell Borders in Windows and macOS.
If there was already a check next to “Show gridlines” but you don’t see lines on your sheet, the color may be too light. Click the “Gridline color” menu to choose a darker gray color.
Click the name of the sheet you want to print at the bottom of your workbook. Click the Page Layout tab at the top. Click the small arrow at the bottom-right corner of the “Page Setup” panel in the toolbar. Click the Sheet tab. Check the box next to “Gridlines” under “Print. " Click OK. Now when you print this sheet, gridlines will appear on each page.
If you already see gridlines on the page but want to add more obvious borders around certain cells or ranges, see Adding Cell Borders in Windows and macOS. If your workbook is not open to the sheet that doesn’t have gridlines, click the name of that sheet at the bottom of the workbook to open it now.
To customize the actual line used in the border (such as changing a solid line to a dotted line), select one of the line styles from the Styles area. To make the border a different color, choose a color from the Color menu.
To remove cell borders, click the arrow next to the Borders icon in the toolbar, and then choose No Border. Unlike gridlines, cell borders are always shown on printed sheets.
