Click on the total in Column D and a small drop-down arrow appears. Right-click “Table>Totals Row.”Įxcel creates a special row at the bottom which adds up the right-hand column automatically. Near the bottom of this pop-up menu, point to “Table” and more selections will appear. Our little list of data is now a neat little Excel table. Excel saw the word descriptions of each column at the top of our table, so it will use those as headers if the box remains checked. In the window, “My table has headers” is checked. The “Format as Table” window will appear to confirm your data.
TABLEEDIT CONDITIONAL FORMATTING PRO
Pro Tip: If you are going to print your table, stay away from the dark section, it uses quite a bit of costly ink. My favorite is the black header with grey and white rows in the “Medium” section, but you may choose your favorite. On the “Home tab>Styles Section>click Format as Table.” Microsoft has created many table formatting options to choose from. Starting with our top left heading, drag through all the data, from Cell A1 to Cell D4. Remember, there is usually more than one correct way to do things in MS Office. You may also click on Row 5 and hit the “Delete” button, or delete them one at a time. Click on Row 5, then right-click “Delete” to remove the old sums. Click on Cell D5, then click in the formula bar to see.Įxcel has a shortcut to place your data in Table Format to make sums much easier. When we added a row, Excel extended the range to include those numbers. Our total cost in Cell D5 is correct because it is adding up or finding the “sum” of a range of numbers using the “=SUM()” formula. Since that quantity is only adding two numbers, it does not include the “Mandarin Oranges.” Click on Cell A5 and then click in the Formula Bar, and you’ll see Excel’s colors showing you Cell A3 is not included in the sum. Notice that the cell formatting stays the same, and “.6” changes to “$0.60.”ĭo you notice a problem with the total in our “quantity” column? Remember our “quantity” column added together the number of apples sold to the number of oranges sold. “Mandarin Oranges” doesn’t quite fit in Column B, so double-click between “B” and “C” to extend the column width.Ĭhange the price of these smaller oranges to 60-cents by changing the “.75” to “.6” instead. Click on the word “Oranges” in Cell B3, and change it to “Mandarin Oranges” by either editing the cell or typing the new words over the old. We now have two rows of “Oranges.” Let’s change Row 3. Tip: Always click back on the “Home” tab after finishing with another tab, especially if you’re a beginner. Then click off “Show Formulas” and return to our Home tab. Click on “Show Formulas” if you’d like to see this for yourself. When you copy and paste, Excel keeps our formulas “relative” to their rows: the Row 3 formulas use Row 3 cells, and the Row 4 formulas use Row 4 cells. Instead, let’s right-click “Copy Row 3,” then stay on Row 3, and right-click “Insert Copied Cells.” This will insert a new Row 4 with the same information already found in Row 3. The long way would be to right-click “Copy Row 3,” then right-click “Insert Row,” then type and copy our formulas. We need to add “Mandarin Oranges” to the list.
To go back to normal, just click “Show Formulas” again it’s an on/off button.
Click on Formulas tab and in the drop-down menu, go for Formula Auditing section>Show Formulas. Do your formulas match the sample? There is a quick way to check.
0 kommentar(er)
