Excel Formatting Flashcards
(18 cards)
Why format and style your spreadsheet?
- Make it easier to read and understand
- Make it more delicate
is about changing the looks of cells, such as changing colors, font, font sizes, borders, number formats, and so on.
Styling
The most used styling functions are:
Colors
Fonts
Borders
Number formats
Grids
is a command which lets you copy formatting from one cell to another.
format painter
There are two ways to access the styling commands in Excel:
- The Ribbon
- Formatting menu, by right clicking cells
How To Use the Format Painter
1.Select the cell that you want to copy
2. Click the Format Painter button
3. Select a cell or range
are specified by selection or by using Hexadecimal and RGB codes.
Colors
You can apply different characteristics to fonts such as:
Bold
Italic
Underlined
Strike though
You can format fonts in four different ways:
color, font name, size and other characteristics.
Why format borders?
- Make the document more readable and understandable
- Emphasizing key points
Excel offers 6 different border styles:
Solid line
Dashed line
Dotted line
Medium line
Thick line
Double line
Why change number formats?
- Make data explainable
- Prepare data for functions, so that Excel understands what kind of data you are working with.
Examples of number formats:
General
Number
Currency
Time
There are two commands:
Increase Decimal
Decrease Decimal
Why remove grids?
- Make the spreadsheet more readable
- Make the spreadsheet more delicate
How to remove grids
- Click view in the Ribbon navigation bar
- Uncheck gridlines
Regional settings affects a number of things, like:
- Calendar date formatting
- Decimal numbers
- Default currency formatting
- Formula delimiters
are the symbols used to separate arguments in a function.
Formula delimiters
