#How to add an underline in excel how to

In the Format Cells dialog box, switch to the Border tab and choose the line style and color first. It also wipes out the default formatting of the top border on the cells with both the top single border and the double bottom border for the same reason. The remaining rows will default to their original format, which is a single border on top and a double border on the bottom.

#How to add an underline in excel how to

If you want to create a cell border that’s outside of the predefined options, here’s how to draw borders in Microsoft Excel.ĭisplay the table tools layout tab, click in the first cell of the table, and then click and drag the right boundary of the first column to the 1.5 inch mark on the horizontal ruler. The border at the left side of the cell will get applied. This will help to apply border at the left side of the selected cell. On the Home tab, in the Styles group, click the style you’ve created. The following tips will give you some insight into Excel cell borders that may help you use them more efficiently. You will see the Format Cells dialog box. Select the Cells option from the Format menu. You can outline the range by selecting the outline border, which is at the bottom-right position on the border palette. Select the border you want applied to each cell in the range. Change the font size of row 1 to 36 and the font size for the rest of the rows to 18. Select all of the text in the worksheet, and change the horizontal alignment to center align and the vertical alignment to middle align. The problem is that condition 1 above isn’t working properly because it wipes out the top border on the next cell if there is supposed to be one. Based on the result in the C column it would do the conditions above for the B column. I’m feeding this data from another program, where the “C” column will get its values. Lets play with excel by learning basics concepts, tricks and shortcuts to reduce your time and efforts to become an Influencer at your workplace. You can apply borders on any of your cell sides, and you can choose the color for the borders. Adding borders to your cells gives you more control over the appearance of your cell boundaries. Click one or more buttons to unselect the border placement. From the popup menu to open the Format Cells dialog box. They will change tint to show that they’ve been selected. There is one downward pointing arrow available beside Border icon. On the left of the dialog box, there’s a ‘Style’ section, where you can select the type of border you want, like dashed, dotted, thick, double, and more. You could also click on the undo button and try again. If you have removed too much you can drag in the opposite direction. Selecting Erase Border turns the mouse cursor into an eraser Clicking on a border line with the tip of the eraser will remove that border line. You can create lines of various colors by first selecting the color you want and then clicking on the border icon for the border line you wish to draw. This will help to apply border at the top side of the selected cell. The border at the right side of the cell will get applied. This will help to apply border at the right side of the selected cell. To fill more than one cell, select the source cell and press Ctrl + Shift + Right arrow to select additional ones. In Microsoft Excel and other spreadsheet programs, pressing Ctrl + R fills the row cell(s) to the right with the contents of the selected cell. Point to Preset, and select the second effect in the third row of preset effects.Ĭtrl+R in Excel and other spreadsheet programs On the Picture Tools Format tab, in the Picture Styles group, click the Picture Effects button. Click the fifth color in the top row of theme colors.

On the Picture Tools Format tab, in the Picture Styles group, click the Picture Border button. It is the third style in the first row under Medium styles. On the Table Tools Design tab, in the Table Styles group, click the Quick Styles button or click the More button to expand the Table Styles gallery. Adding the Inisde Preset adds the inner border to a group of cells. Clicking on a border icon creates that border line in the Style and Color that you have already selected. Clicking on the border button again will remove that border. Using The Border Control In The Home RibbonĬlicking on a border button puts that border in the cell.