How to remove existing borders and fills in Excel

Let’s take a look.

Both borders and fills can be removed using menus on the ribbon.

First, go for the cells you’d like to change.

To remove all borders, select No Border from the Border menu.

This command will remove all borders completely.

To remove all fills, select No Fill from the Fill color menu on the ribbon.

This will completely remove all fills, including patterns and gradients.

Borders and fills can also be removed using the Format Cells dialog box.

Let’s undo and look at that option.

To remove borders using Format Cells, navigate to the Border tab and poke the None preset.

To remove fills, jump into the Fill tab and click No Color.

Changes take effect when you smack the OK button.