Formatting in Excel

Réussis tes devoirs et examens dès maintenant avec 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

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

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

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


Ensembles d'études connexes

ME 310 Manufacturing Processes Final

View Set

Unknown questions: Pharmacology_Cloned_Assessment 30

View Set

AP HG Ch.13 study guide Urban Patterns

View Set

Science - Ch. 4 Lesson 2 Rocks & Rock Cycle

View Set