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 color and …

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 styles. …

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 has price …

Select any cell within the row, then go to Home > Insert > Insert Sheet Rows or Delete Sheet Rows. Alternatively, right-click the row number, and then select Insert or Delete.

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.

Although Excel offers no direct control for line spacing within a cell, you can use several text alignment strategies to adjust white space or make the text more readable.

Use the clean excess cell formatting tool to remove unused formatting that could be causing problems with your workbook.

You can clear cells to remove the cell contents (formulas and data), formats (including number formats, conditional formats, and borders), and any attached comments. The cleared cells remain as blank or …

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