Formatting in Excel
Format Cells
Adjust row height or column width
Merge and Center
Combine selected cells and centre the text in the combined cell
Match destination formatting
Format the content being pasted into a cell according to the styles used in the worksheet, rather than the styles of the source document
Increase indent
Increase the margin between the border and the text in a cell
Orientation
Rotate text to display at a given angle
Page Layout
Tab where there are settings that affect how a worksheet is printed
Home
Tab with most of the tools for formatting a cell or cell range
Review
Tab with the tool to add a comment about the selected cell
Accounting Number Format
Display cell content as currency with 2 decimal places, comma thousands separator and a currency symbol
Percent style
Display the value of a cell as a percentage
Comma style
Display the value of a cell with commas separating thousands
Wrap Text
Make all text in a cell visible by displaying it on multiple rows
Fill Colour
Set the background colour of selected cell/s
Select whole worksheet
Triangular icon in space to left of column A and above row 1 which when clicked allows formatting changes for everything in a worksheet
Conditional formatting
Tool that allows you to specify rules for cells to display differently depending on their values
Format painter
Tool to copy the formatting of a selected cell to another cell or range of cells
Middle Align
Tool to position text in the middle relative to cell height
Center
Tool to position text in the middle relative to cell width
Clear
Tool with option to remove all formatting from selected cell/s
Cell Styles
Tool with pre-set styles for headings, warning text and row or column labels for example