Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about formatting cells in Excel here.
Cell borders and fill colors allow you to create clear and defined boundaries for different sections of your worksheet. Below, we'll add cell borders and fill color to our header cells to help distinguish them from the rest of the worksheet.
You can draw borders and change the line style and color of borders with the Draw Borders tools at the bottom of the Borders drop-down menu.
If you want to copy formatting from one cell to another, you can use the Format Painter command on the Home tab. When you click the Format Painter, it will copy all of the formatting from the selected cell. You can then click and drag over any cells you want to paste the formatting to.
Watch the video below to learn two different ways to use the Format Painter.