In Excel, there are options to add both predefined cell borders and custom cell borders. Click on a cell in the worksheet. On the Home tab in the Font group, you will see a border icon ...
In this Excel tutorial, I’ll show you a quick and easy way to delete blank cells, which you might think of as rows, in the middle of a dataset without accidentally deleting adjacent data.
To remove the excess formatting from your current Excel file, go to the Inquire tab and choose the Clean Excess Cell Formatting option. Once excess formatting is removed, click Yes to save changes ...