You can use this to copy formatting from one area to another. Use format painterįormat painter is a beautiful tool part of all Office programs. To apply cell styles, just select all the cells you want to have same style and from Home ribbon, select the style you want (from styles area). For example, you can color all input cells in orange color, all notes in light gray etc. By using cell styles, you can ensure that all similar information in your workbook is formatted in the same way. Use cell stylesĬonsistency is an important aspect of formatting. What more, you can even define schemes for fonts or combine both and create a new theme. You can also define your own color schemes (to match corporate style). These are well contrasted and look great on your screen. Microsoft has defined some great color schemes. Just go to Page Layout ribbon and choose a color scheme from Colors box on top left. And you want to change colors to something fresh. So you have made a spreadsheet model or dashboard. This has to be the best and easiest formatting tip. And bingo, your data looks slick in no time.
Just select any cell with in the data and press CTRL+T and then Enter. Use tables to format data quicklyĮxcel Tables are an incredibly powerful way to handle a bunch of related data. So, today, lets talk Excel formatting Tips. But not many of us have so much of time or energy. There you can edit the value in the Address field to whatever page or file you wish to use instead.Īre you having trouble getting your spreadsheet to print well? Check out our Excel printing optimization guide for some tips that can solve a few of the problems you may be experiencing.We can take any Excel workbook and format it until Christmas, and we would still not be done. If you want to edit the hyperlink so that it opens to a different Web page or file than what it is currently opening to, then you can right-click on the cell and choose the Edit Hyperlink option, which will open the Edit Hyperlink dialog box. You can change the color of the hyperlink text by selecting the cell, choosing the Home tab, then clicking the arrow next to the Font Color button in the Font group, then choosing the desired text color. This may be a preferable option if you would prefer to keep the text coloring from the hyperlink, and only want to remove the underline. This is also how you would apply underline formatting to text. You will need to select the cell with the underline, click the Home tab, then click the Underline button in the Font group of the ribbon. You can also select the entire spreadsheet by pressing the Ctrl + A keyboard shortcut, or by clicking the gray button above the row 1 heading, and to the left of the column A heading.Īnother way that you can remove the underline from a hyperlink also applies to other text that has an underline. You can select multiple cells at a time in Microsoft Excel by clicking and dragging, or by holding down the Ctrl key on your keyboard and clicking each cell that you want to select. In this article, we take advantage of that to remove the link text color and underline, but you can also use it to remove formatting from other cells in your spreadsheet as well. Note that when you select a cell and choose the “Clear Formats” option, it will get rid of most of the formatting that has been applied to that cell. Step 2: Click the cell containing the hyperlink whose underline and color you wish to remove. Step 1: Open the spreadsheet in Excel 2013.
Note that the steps below focus on performing this action on one link, but you can do it to multiple links by selecting a range of cells instead of just a single one. If you would prefer to remove the hyperlink and its formatting, then read this article on removing hyperlinks in Excel 2013.
You will still be able to click the link, however, if you so choose.
#HOW TO ADD UNDERLINE IN EXCEL TOOLBAR HOW TO#
The steps in this article will show you how to change the formatting of a hyperlink (or hyperlinks) in an Excel 2013 spreadsheet. How to Remove the Underline and Color from a Hyperlink in Excel 2013 (Guide with Pictures) Our guide continues below with additional information on removing underlines from links in Excel, including pictures of these steps. 4 Additional Reading How to Remove Underline from Link in Excel 2013