Formatting in Excel

¡Supera tus tareas y exámenes ahora con Quizwiz!

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


Conjuntos de estudio relacionados

Chapter 11 - How to Take and Study Notes

View Set

Organizational Behavior Chapters 1-4

View Set

Ch.1 Legal Heritage and the Digital Age

View Set