Excel Ribbons

CTS130-900

Home Tab

* Clipboard

1. Paste: Paste items that were copied

2. Cut: Remove highlighted items

3. Copy: copies highlighted items

4. Format painter: Similar to “copy”, but keeps the format as well as the text.

* Font

1. Bold: Makes text darker + bigger

2. Italics: Skinnier text that leans forward

3. Underline: Underlines text

4. Grow font: increase font size

5. Shrink font: decrease font size

6. Fill color: Colors background of selected cell

7. Font color: changes text color

8. Bottom border: adds a border around selected area

* Alignment

9. Top align: Align text to top of cell

10. Middle align: Aligns text so its center from top to bottom of the cell

11. Bottom align: Aligns text to the bottom of the cell

12. Orientation: Allows you to rotate the text

13. Align text left: Moves text to left side of paper

14. Center: centers up the text on paper

15. Align text right: Moves text to the right side of the paper

16. Decrease indent: Decrease the amount of indention

17. Increase indent: Moves the text further right

18. Wrap text: makes the text in selected cells visible

19. Merge and center: merges selected cells into one cell and centers the content

* Number

1. Accounting number format: changes the currency format of a cell

2. Number format: choose how the values of the numbers are displayed

3. Percent style: displays the value as a percentage

4. Comma style: insert thousands separator

5. Increase decimal: moves the decimal place to the left (larger)

6. Decrease decimal: moves the decimal place to the right (smaller)

* Styles

1. Conditional formatting: allows you to create rules by visual data bars, color scales, and icon sets

2. Format as table: puts data into a table

3. Cell styles: choose a premade format and adds it to a cell

* Cells...