Let’s take a look. Here we have a table with several rows of sample text. The top three rows contain a single line of text. The bottom three rows contain larger amounts of text. The options available for vertical alignment in Excel are listed across the top of the table. Let’s format the text in each column to match the headings. For column C, we smack the Top Align button....
Abstract Transcript Borders build directly on Excel’s grid system. Let’s take a look. Before you apply borders, you may want to turn off the gridlines that appear by default in Excel. This will make it easier to see the borders you create. you could turn off gridlines by unchecking Gridlines on the Layout tab of the ribbon. To apply a border, first snag the cells you’d like to add borders to....
There are quite a few options in this menu. The key is to choose the line style and line color before choosing the presets. Let’s take a look. The border menu is on the home tab of the ribbon, inside the font group. It contains a long list of border presets. To use these presets, set the line style and the line color first. We aren’t drawing borders in this case, so we’ll need to turn that off....
Abstract Transcript In this lesson we’ll look at cell fills. Fills define the background color of cells. They are a key tool in building good-looking and easy to read worksheets. Let’s take a look. To apply a fill, start by selecting the cells you want to fill. Then, launch the Format Cells dialog box and navigate to the Fill tab. There are two basic types of fills. The first is a solid background color....
Abstract Transcript Sometimes you might createnamed rangesafter you’ve already built formulas. In that case, Excel will not automatically update the formulas to use the named ranges. However, there are a couple of ways you could apply named ranges to formulas that already exist. Let’s take a look. Here we have a table that shows hours worked and gross pay for a small team. Now lets say you want to convert these formulas to use a named range....
Abstract Transcript Excel ships with a number of pre-built pivot table styles. Using these styles, you’re free to format an entire pivot table with a single click. Let’s take a look. Pivot table styles are available on the Design tab of the PivotTable Tools ribbon. To apply a pre-built style, select any cell in the pivot table and navigate to the Design tab. All available styles are listed in the PivotTable styles group....
Table styles control the look and feel of anExcel Table. You’ll see a large number of pre-built styles organized in several categories. Table styles are grouped in three categories: light, medium, and dark. When you find a style you like, just click to apply the style to the table. Notice the currently applied style will be highlighted in the list. it’s possible for you to use Undo to revert to a previous style....
All of these styles can be applied individually or together. Let’s take a look. First, let’s left-align the headings and reduce the font size a bit. We can do all of this using the controls on the ribbon. To bold the headings, just poke the bold button on the ribbon. Notice that the bold button is now highlighted. To reset the bold style, just hit the button again. The italic and underline styles work the same way....
Formulas allow you to make powerful and flexible conditional formatting rules that highlight just the data you want. Let’s take a look. The main requirement is that the formula return either TRUE or FALSE. When a formula returns TRUE, the rule is triggered and the formatting is applied. There is no preset for this, so we’ll need to use a formula. The easiest way to test for odd numbers is to use a special function called ISODD....
Abstract Transcript Excel provides both single and double underlining. It also provides a special variant of each for numbers using the Accounting format. Let’s take a look. For most basic underlining, you’re free to just use the Underline button on the ribbon. The Underline button toggles underlining on and off. It also provides a menu for selecting single and double-underlining. The Underline button remembers your last selection. Excel actually provides two more underline options for use with the Accounting number format....
In this worksheet we have a chart with basic formatting. In either case, start by selecting the chart area. For example, I can change the font size to 12, and make all text blue. Note this also affects text that’s not visible. If I unlock the legend, that text is now blue as well. you’re free to also make changes to a single element in the chart. For example, if I grab the chart title, I can change the color to red....
The General format is Excel’s default format for all cells. In a new worksheet, all cells have this format. Let’s take a look. The General format has just two basic rules. When the column width is increased or decreased, Excel will adjust the number of visible decimal places automatically. If the width of a column is decreased, the number will be rounded as needed. The actual cell values remain unchanged.
Let’s take a look. There are two basic paths to horizontal alignment in Excel. The second path is the Alignment tab on the Format Cells dialog box. The Format Cells dialog is more complete and gives you access to all the cell alignment options in Excel. In the Format Cells dialog box, this default alignment is referred to as “General” alignment. However, you’ve got the option to override Excel’s default alignment as you like....
