![give columns different headers in excel 2016 give columns different headers in excel 2016](https://support.content.office.net/en-us/media/0cf61bba-56d2-4b1e-9a49-e69553797326.jpg)
Let's do something a little different now. Instead of applying a border, we're going to go to the Draw Borders section of the dropdown menu. We're going to draw borders.
![give columns different headers in excel 2016 give columns different headers in excel 2016](https://www.excelcampus.com/wp-content/uploads/2016/01/Overview-of-Dates-in-Excel-640x360-Youtube-Video-Thumb.png)
Since we selected a range of cells, the border is applied to the entire range, not the individual cells. Next, we go to the Ribbon and click the Borders button. We want to apply borders to the cells in column A.Īs you can see below, we've selected the cells.
![give columns different headers in excel 2016 give columns different headers in excel 2016](https://cdn.ablebits.com/_img-blog/excel-sort/sort-by-columns.png)
You can also change the line color of the border and the border style (such as dashed or solid lines) by going to the Draw Borders section of the dropdown menu. Simply select where you want to border to appear and what kind of border you want. Keep in mind that the border you choose will be applied to a single selected cell or to a range of selected cells. When you click on the Border button, you will see this dropdown menu: You can also add borders to cells or a range of cells by selecting the cell(s) you want to add border to, then by clicking Border button in the Font group under the Home tab. Once you select the font, the selected data will be changed to the new font. Go to the Font group, and you'll see the type of font that you're currently using. It appears in a box with a downward arrow beside it on the left hand side of the toolbar. In our example, and on our toolbar, it's Calibri.Ĭlick on the downward arrow to the right font type and select a new font. Next, select the data in the worksheet for which you want to change the font. We've selected column A in the snapshot below. To change the font type and size, go to Font group under the Home tab. However, we can change that to another font and another size. In the snapshot below, we've used Calibri, size 11 font. Font is defined as the style of your type. Times New Roman, Courier, and Arial are probably three of the most popular fonts, but there are literally hundreds. When you create a worksheet, you can decide what type of font you want to use. You can also decide the size of the font.