If you apply a fill color to cells on a worksheet, you won't be able to see or print the cell gridlines for those cells. To see or print the gridlines for these cells, you must remove the fill color.

To customize the line style or color of cell borders or erase existing borders, you can use the Draw Borders options. To draw cell borders, you'll first select the border type, then the border …

Select the cells, rows, or columns that you want to delete. Right-click, and then select the appropriate delete option, for example, Shift cells up, Shift cells left, Entire row, or Entire column.

Tip When you change the fill colors of the cells on a worksheet, the gridlines can become difficult to see. To make the gridlines stand out on the screen, you can experiment with border and line …

Click the line, connector, or shape that you want to delete, and then press Delete. If you want to delete multiple lines or connectors, select the first line, press and hold Ctrl while you select the …

Select the cell or range of cells where you want to remove the borders. On the Home tab, in the Font group, click the arrow next to Border , and then click No Border.

Right-click inside the cell you want to change, and click Format Cells. On the Alignment tab, change Vertical to Top, Center, or Bottom, depending on where you want your text to be …

Select Data > Remove Duplicates, and then under Columns, check or uncheck the columns where you want to remove the duplicates. For example, in this worksheet, the January column …

Add, adjust or remove page breaks in Excel using Page Break Preview. Also, learn how to reset and hide page breaks.

You can filter for unique values to temporarily hide duplicate values, and you can remove duplicate values to permanently delete duplicate values. A duplicate value is one where all …