Excel Lesson 6 Align Cells Align means to position contents in a cell horizontally or vertically Text Orientation used to rotate text to a vertical or diagonal angle in a worksheet IncreasingDecreasing Indent increasesdecreases the margin between the border and the text in an indented cell ID: 541206
Download Presentation The PPT/PDF document "Formatting Cells" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Formatting Cells
Excel Lesson 6Slide2
Align Cells
Align means to position contents in a cell horizontally or vertically
Text Orientation: used to rotate text to a vertical or diagonal angle in a worksheet
Increasing/Decreasing Indent: increases/decreases the margin between the border and the text in an indented cellSlide3
Formatting Cells
Font:
Defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel
Measured in points (72 points = 1 inch)
Font size can be changed by clicking on the Decrease Font Size or Increase Font Size icons
Character:
A letter, number, punctuation, mark, or symbol
(John Wiley & Sons, Inc., 2012)
Default:
a predefined setting
(John Wiley & Sons, Inc., 2012)
The default font for Excel is CalibriSlide4
Formatting Cells
Attribute:
A formatting characteristic of text or a cell
Bold
Italics
UnderlineSlide5
Formatting Cells
Mini
Toolbar:
Toolbar that appears when text is selected. It includes formatting options such as Bold and Font.Slide6
Formatting Cells
Applying Number Formats:
General:
default format
Number:
used to display numbers
the number of decimals can be adjusted
Currency:
used to display the money sign
Accounting:
used for monetary values
(John Wiley & Sons, Inc., 2012)
Used when you want to dollar sign and decimals to align in a column
(John Wiley & Sons, Inc., 2012)
Date:
Used to display dates
The format of dates can be
changed
Text: Data not used in a calculation
If you see ###### in a cell, it means that the cell is not wide enough for its
contents – you use AutoFit to adjust the widthSlide7
Formatting Cells
Wrap Text
: allows the text in a cell to continue onto a second and succeeding lines
Home > Alignment Group
The row height will automatically be adjusted once text is wrapped in a cell
(John Wiley & Sons, Inc., 2012)
To do a manual line break in a cell, press Alt + Enter and the point you want the text to go to the next lineSlide8
Formatting Cells
Merged Cells:
cells created by combining two or more adjacent horizontal or vertical cells
Home Ribbon > Alignment Group
Only data from the first cell (upper-left) cell will appear in the merged cell…all of the data that was located in other cells that were merged are deleted
Can be merged both horizontally and vertically
(John Wiley & Sons, Inc., 2012)
Split Cells
: splitting a cell into multiple cells
Home Ribbon > Alignment Group
Only cells that have already been merged can be splitSlide9
Formatting Cells with Styles
Style:
allows the user to format a cell or selected cells quickly by choosing from a defined list
Home > Styles Group
Cell styles can be modified, added or deleted
Only the Normal style cannot be deleted
When you apply a style to text, any conflicting formatting in the cell or range is replaced by the style format.
(John Wiley & Sons, Inc., 2012)Slide10
Formatting Cells with Styles
The cell styles options allows you to change the font color, font type, and heading styles for cell’s content
(John Wiley & Sons, Inc., 2012)
The style options dialog box will be opened by right-clicking on the built-in Cell Style and selecting any option from the drop-down menu
(John Wiley & Sons, Inc., 2012)Slide11
Copying using Format Painter
Format Painter:
An Excel feature that allows you to copy formatting from a cell or range of cells to another cell or range of cells
(John Wiley & Sons, Inc., 2012)
If you double click on the icon, it will turn Format Painter On and leave it on until you turn it offSlide12
Linking to Other Data
Hyperlink:
A shortcut or jump that opens a document stored on a network server, an intranet or the Internet
(John Wiley & Sons, Inc., 2012)
Target:
File or webpage that you are linking to
Hyperlinks are blue and underlined and turn to purple once clicked
Hyperlinks can be removed easily by right clicking on the cell and choose Remove Hyperlink
Text will not be deletedSlide13
Conditional Formatting
Conditional Formatting:
Formatting that appears only when the value in a cell meets conditions specified by a user
If conditional formatting is applied, it will override manual
formatting
Rules Manager:
allows the user to set multiple rules for a specifi
c cellSlide14
Clear Formatting
Allows the user to clear formatting, not text
Home Ribbon > Editing GroupSlide15
Source
Microsoft Official Academic Course Microsoft Excel 2013
. John Wiley & Sons, Inc., 2014.
John Wiley & Sons, Inc. (2012). Microsoft Official Academic Course Microsoft Excel 2010, Exam 77-882.