The Format paintbrush copies everything related to the formatting of a selected cell. When you select a cell and click Format, you can then highlight a whole range of cells, and each one will take on the formatting of the original cell, without changing their values.
The Paste tool can paste anything in your clipboard into the selected cell, and typically retains everything including the value, formula, and format. However, Excel has a wealth of pasting options: you can access these by clicking the down arrow next to the Paste icon. You can paste what youve copied as a picture. You can also paste what youve copied as values only, so that instead of duplicating the formula of a copied cell, you duplicate the final value shown in the cell.
C. Position Formatting Tools: Align cell data to the top, bottom, or middle of the cell. There is also an option for angling the values displayed, which can make it easier to read. The bottom row has familiar options for left, center, and right alignment. There are also indent right and left buttons.
Excel also has close tie_ins with Microsoft Access, a database program, which can add power. In general, Excel integrates best with databases and any dataset requiring many calculations per workbook.