where is the quick analysis button in excel 2013

A formatting style is a collection of formatting choices. If you frequently use the same formatting options for the cells in your worksheets, you may want to create a formatting style to save you time. We could also apply conditional formatting to a selection of blank cells so the data is 'flagged' when it meets the criteria. You can choose different highlight colors from the drop-down menu.Īs you can see in our snapshot below, the cells over $50 are now highlighted. We want to format cells that are greater than $50, so we're going to enter that into the box. We chose Greater Than from the side menu that appears when you click Highlight Cell Rules. We want to cells to be highlighted when a value is greater than $50.

Now, we go to Conditional Formatting on the Ribbon and choose Highlight Cell Rules. Let's apply conditional formatting to our spreadsheet.įirst, we select the cells. Manage Rules opens a dialog box where you can edit and delete rules. You can apply these icons to a cell selection to indicate values relative to each other by clicking the color scale thumbnail.Ĭlear Rules allows you to remove conditional formatting rules for the cell selection. Icon Sets will open a palette with icons. You can apply these to a cell selection to indicate their values relative to each other.Ĭolor Scales opens a palette with different color scales that you can apply to a cell selection to indicate their values relative to each other. Top/Bottom Rules gives you options for defining rules that highlight the top and bottom values, percentages, and above- and below-average values in a cell selection.ĭata Bars opens a palette with different colors of data bars. Highlight Cells Rules allows you to define rules that highlight the cells in the cell selection when certain values, such as text or dates, have greater or lesser than a value that you specify, or fall within a range of values. Let's learn what each of the options does for you: To apply conditional formatting, go to the Styles group under the Home tab. Did you know that you Excel can notify you each time this happens? You can program MS Excel 2013 to give you a 'red flag' every time a certain situation exists. Your boss has told you to let him know if anyone exceeds more than eight hours in any given day. Let's say you're entering an employee's work hours into a spreadsheet. Last Column puts row headings in the last column of the table in boldface.īanded Columns applies shading to every other column.Ĭonditional formatting is a neat little feature of MS Excel 2013, because it helps you do your job better. Total Row goes at the bottom of the table for totals.īanded Rows means shading will be applied to every other row.įirst Colu mn puts row headings in the first column in boldface. Ours already has filter buttons (the down arrow). Header Row adds formatting and filter buttons to each of the headings in the first row. In the Design tab is a Table Styles Options group that allows you customize even further. In addition to adding formatting from the gallery, the Design tab opens in the Ribbon. If your table has headers or labels, make sure the box is checked. This contains the cells referenced for the formatting. When you click on a style you want, you'll see this dialog box: Now we're going to go to the Format As Table button and look at the gallery. We're going to put our mouse cursor in a cell by clicking on the cell. Your cell cursor just has to be within the table of data right before you click the Format As Table button that's located in the Styles group under the Home tab (pictured below). Think of it as a shortcut to formatting cells. The Format As Table Gallery is a way to format your cells without having to select the cells first. To change the size, select the cells, then click the downward arrow beside the current size: Once you select the font, the selected data will be changed to the new font. In our example, and on our toolbar, it's Calibri.Ĭlick on the downward arrow beside the font type and select a new font. It appears in a box with a downward arrow beside it on the left side of the toolbar.

Go to the Font group, and you'll see the type of font that you're currently using. Next, select the data in the worksheet for which you want to change the font. To change the font type and size, go to Font group under the Home tab. You can clearly see how just changing the font type and size can alter the look of a worksheet.

However, we can change that to another font and another size. In the snapshot below, we've used Arial, size 10 font. You can also decide the size of the font. When you create a worksheet, you can decide what type of font you want to use. Times New Roman, Courier, and Arial are three of the most popular fonts, but there are literally hundreds. Font is defined as the style of your type.

Where is the quick analysis button in excel 2013