Important: Keyboard shortcut keys can only be used in Windows, not in Android.
Module 2: Formatting cells and ranges
Changing the font, font size, and font color
Aligning text
Applying borders and shading
Merging and splitting cells
Number format
Wrap text and Cell Style
Formatting Commands in Excel
Font
A font is a collection of characters, symbols, and glyphs that share a common design and are used to display text in a specific style. Fonts can be used for various purposes such as creating logos, designing websites, and publishing books.1
There are many different types of fonts available, each with its own unique personality. Some fonts are more formal and elegant, while others are more casual and fun. Some fonts are designed to be easy to read, while others are more decorative.
Here are some examples of different types of fonts:
Serif fonts have small decorative lines at the ends of their strokes. They are often considered to be more formal and elegant than sans-serif fonts. Examples of serif fonts include Times New Roman, Georgia, and Garamond.
Sans-serif fonts do not have the decorative lines at the ends of their strokes. They are often considered to be more modern and casual than serif fonts. Examples of sans-serif fonts include Arial, Helvetica, and Futura.
Script fonts resemble handwritten text. They are often used for invitations, greeting cards, and other formal documents. Examples of script fonts include Brush Script, Calligraphy, and Freestyle Script.
Decorative fonts are designed to be eye-catching and decorative. They are often used for headlines, logos, and other graphic design elements. Examples of decorative fonts include Comic Sans, Trajan Pro, and Papyrus.
Fonts are used in Excel to change the style and size of text and characters in a document. Changing the font of your numbers and text in an Excel worksheet can help your document to look more appealing and, at times, make it easier for the reader to digest the information.
Excel provides users with a pre-selected font that they may use when creating workbooks. A default font can play an important role in your document’s appearance and reader comprehension
Font Size
-The font size or text size is a number that measures the size of characters (such as letters, numbers, and punctuation marks) on a screen or printed page 1. In computing and web design, font sizes can be defined in units of pixels (px), points (pt), or ems (em).2
In Microsoft Excel, changing the font size of your numbers and text can help your document to look more appealing and make it easier for the reader to digest the information.
Bold
In Microsoft Excel, bold is a font style that makes text appear thicker and darker than the surrounding text.
It is used to emphasize important information or to make headings stand out in a table or spreadsheet.
In Microsoft Excel, Italic font style is a type of text formatting where the letters are tilted to the right. It is used to emphasize important information or to make headings stand out in a table or spreadsheet.
In Microsoft Excel, underline is a font style that adds a line below the text.
The underline command is used to draw attention to specific text or data in a table or spreadsheet. It can be used to indicate headings, subheadings, or important information that needs to be highlighted. Underlining can also be used for emphasis when bold or italic formatting is not appropriate.4
In Microsoft Excel, strikethrough is a font style that adds a line through the middle of the text.
The strikethrough command is used to indicate that certain information is no longer relevant or has been deleted. It can also be used to show completed tasks in a table or spreadsheet.5
To apply a specific font in Excel on both Windows and the mobile app, follow these steps:
On Windows (Excel Desktop App):
Open Excel and select the cell(s) where you want to apply the font.
In the Home tab, locate the Font group.
Click the Font drop-down menu to view available fonts.
Select the desired font from the list.
You can also adjust the font size, bold, italic, or underline from the same section if needed.
On Mobile (Excel App):
Open Excel on your mobile device and open the spreadsheet.
Select the cell(s) where you want to change the font.
On your Android phone, you can expand the ribbon by tapping the edit icon (which is usually located in the top). You can collapse the ribbon by tapping the down arrow Down arrow. read more …
Tap Font to open the font options.
Choose the desired font from the list.
You can also change the font size, bold, or italic here.
Borders
In Microsoft Excel, cell borders are lines that surround a cell or range of cells. They are used to visually separate data in a table or spreadsheet and make it easier to read and understand.
Cell borders that you apply on cell in sheets to appear on printed pages.
By using predefined border styles, you can quickly add a border around cells or ranges of cells. If predefined cell borders do not meet your needs, you can create a custom border.6
On a worksheet, select the cell or range of cells.
On the Home tab, in the Font group, To apply a new or different border style, click the arrow next to Borders , and then click a border style.
Remove a cell border [Windows]
On a worksheet, select the cell or range of cells that you want to remove a border from.
On the Home tab, in the Font group, click the arrow next to Borders , and then click No Border.
Fill Color
n Microsoft Excel, Fill Color is a feature that allows you to add or change the background color.
It is used to highlight data in cells and make it easier to read and understand. 7
Font Color
In Microsoft Excel, Font Color is a feature that allows you to change the color of the text in a cell or range of cells.[^10]
Data Alignment
In Microsoft Excel, data alignment refers to the position of data within a cell or range of cells.
Align text in a cell [Windows] [^11] [^12]
Select the cell or range of cells that contains the data that you want to reposition.
On the Home tab, in the Alignment group, do one or more of the following:
To change the vertical alignment of cell contents, click Top Align , Middle Align , or Bottom Align .
To change the horizontal alignment of cell contents, click Align Text Left , Center , or Align Text Right .
Merge & Center
Merge and Center is a feature in Microsoft Excel that allows you to combine two or more cells into one cell and align the contents of the merged cells in the center.
This feature is useful when you want to create a label that spans multiple columns or rows, or when you want to merge cells containing text or numbers into a single cell.
You can’t split an individual cell, but you can make it appear as if a cell has been split by merging the cells above it. 8
Select two or more adjacent cells that you want to merge.
On the Home tab, in the Alignment group, click Merge and Center.
Merge adjacent cells [Android]
Select the cells to merge.
Tap Merge & Center.
Unmerge cells [Windows]
Select the merged cell.
When you select a merged cell, the Merge and Center button also appears selected in the Alignment group on the Home tab.
To split the merged cell, click Merge and Center .
Unmerge cells [Android]
Select the Merged Cell
Tap again Merge & Center.
Wrap Text
In Microsoft Excel, Wrap Text is a feature that allows you to display the contents of a cell on multiple lines, rather than one long line.
This feature is useful when you have lengthy text in a cell that is difficult to read or when you want to fit more text into a smaller space.
By enabling Wrap Text, you can ensure that all the content is visible without having to adjust the column width or are left with text overflowing into neighboring cells. [^14] [^15]
Wrap text automatically - Windows
In a worksheet, select the cells that you want to format.
On the Home tab, in the Alignment group, click Wrap Text.
Important: Data in the cell wraps to fit the column width. When you change the column width, data wrapping adjusts automatically.
Enter a line break - Windows
To start a new line of text at a specific point in a cell, double-click the cell, click the location where you want to break the line in the cell, and then press ALT+ENTER.
Format Painter
The Format Painter is a useful tool in Microsoft Excel that allows you to copy formatting from one cell or range of cells and apply it to another cell or range of cells.
Use Format Painter to quickly apply the same formatting, such as color, font style and size, or border style, to multiple pieces of text or graphics. 9
Notes:
You can use Ctrl+Shift+C to copy a format, and Ctrl+Shift+V to paste a format. While the cursor does not change to a paintbrush, you can repeatedly paste formatting to multiple areas without re-copying.
Cell Styles
A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading.
To apply several formats in one step, and to make sure that cells have consistent formatting.
Apply a cell style
Remove a cell style from data
Number Format
Excel provides a variety of number formats that you can apply to the values (numbers) you enter in a worksheet to make the data easier to interpret.
These number formats include:
currency, accounting, percentage, date, time, fraction, and scientific, as well as a few special formats.
On the View tab, in the Show/Hide group, clear the Gridlines check box.
Show gridlines on a worksheet
Select one or more worksheets.
On the View tab, in the Show/Hide group, select the Gridlines check box.
Change the color of gridlines in a worksheet
Click the Microsoft Office Button, and then click Excel Options.
In the Advanced category, under Display options for this worksheet, make sure that the Show gridlines check box is selected.
In the Gridline color box, click the color you want.
Which of the following is NOT a valid font style in Excel?
Bold
Italic
Underline
None of the above
Which of the following is NOT a valid number format in Excel?
Currency
Date
Percentage
Text
None of the above
What is the primary function of the Format Painter tool in Excel?
To copy and paste formatting from one cell or range of cells to another.
To apply a specific font style to a selected range of cells.
To adjust the alignment of text within cells.
To change the border style of selected cells.
What is the advantage of using the Format Painter tool compared to manually applying formatting to multiple cells?
It saves time and effort when applying consistent formatting to multiple cells.
It allows you to apply a wider range of formatting options than are available in the Format Cells dialog box.
It ensures that all formatting is applied differently to all selected cells.
It allows you to preview the formatting changes before applying them to the selected cells.
What happens to the contents of the other cells when you merge two or more cells?
The contents of the other cells are copied to the merged cell.
The contents of the other cells are moved to the merged cell.
Merging cells only keeps the upper-left value and discards other values
The contents of the other cells remain unchanged.
What is the purpose of using Merge and Center in Excel?
To combine two or more cells into a single cell.
To center the text in a cell.
To do both of the above.
Neither of the above.
What is the purpose of wrapping text in Excel?
To make text fit within the width of a cell
To change the font of text
To add a border to cells
To protect cells from being edited
What happens when you wrap text in Excel?
The text is moved to a different cell.
The text is hidden.
The text is displayed on multiple lines within the same cell.
The text is deleted.
What is the effect of wrapping text on the row height?
The row height decreases.
The row height increases.
The row height remains the same.
The row height varies depending on the amount of text in the cell.
Which of the following is the default alignment for text in Excel cells?
Left
Right
Center
Justify
Which of the following number formats is used to display numbers with decimal places?
General
Number
Currency
Accounting
Which of the following number formats is used to display numbers as percentages?
General
Number
Currency
Percentage
Which of the following number formats is used to display negative numbers in red?
General
Number
Currency
Accounting
What is the default font in Excel?
Arial
Calibri
Times New Roman
Courier New
How can you make a font bold in Excel?
Use the keyboard shortcut Ctrl+D.
Use the keyboard shortcut Ctrl+B.
Use the keyboard shortcut Ctrl+I.
Use the keyboard shortcut Ctrl+U.
Which of the following font sizes is best for body text?
10
12
14
16
18
You can format numbers as currency in Excel without changing the actual value.
True
False
Which of the following options allows you to add borders to cells in Excel?
(a) Fill Color
(b) Border button in the Home tab
(c) Merge Cells
(d) Text Orientation
Correct Answer: (b) Border button in the Home tab
To change the background color of a cell in Excel, you can use the _____ option in the Home tab.
(a) Font Color
(b) Fill Color
(c) Cell Styles
(d) Alignment
Correct Answer: (b) Fill Color
Which of the following is used to adjust the width of a column in Excel?
(a) Resize Column
(b) AutoFit Column Width
(c) Format Cells
(d) Wrap Text
Correct Answer: (b) AutoFit Column Width
Which of the following is used to display numbers with commas for thousands in Excel?
(a) Currency Format
(b) Accounting Format
(c) Number Format
(d) Comma Style
Correct Answer: (d) Comma Style
The “Format as Table” option in Excel applies a predefined table style and makes it easier to manage data.
Correct Answer: True
What is the keyboard shortcut to format cells in Excel?
* a. Ctrl + Shift + F1
* b. Ctrl + 1
* c. Alt + F4
* d. Ctrl + Alt + Delete
* Answer: b. Ctrl + 1
What is the purpose of the ‘Merge & Center’ function?
* a. To align text to the right.
* b. To combine selected cells into one larger cell and center the content.
* c. To apply a background color.
* d. To change the font color.
* Answer: b. To combine selected cells into one larger cell and center the content.
*How can you change the column width to fit the content automatically?**
* a. Double-click the right edge of the column header.
* b. Right-click and select ‘Auto Column’.
* c. Use the ‘Format’ menu and select ‘AutoFit Column Width’.
* d. A & C options.
* Answer: d.
Which tab in Excel contains the “Cell Styles” option for quick formatting?
a) Insert
b) Data
c) Home
d) Formulas
Answer: c) Home
The “Wrap Text” feature automatically adjusts the row height to fit all text in a cell.
a) True
b) False
Answer: a) True
The keyboard shortcut to apply Strikethrough formatting in Excel is ____.
a) Ctrl + 5
b) Ctrl + D
c) Ctrl + T
d) Alt + S
Answer: a) Ctrl + 5
Exercises
Review Questions
What is the purpose of formatting in Excel, and why is it important?
What is the difference between cell formatting and cell value?
How do you apply formatting to a range of cells?
How do you clear formatting from a range of cells?
Explain the purpose of the Format Painter tool in Excel and how to use it.
Explain the purpose of the “Fill Color” and “Font Color” options in Excel and how to use them effectively.
How do you change the text color in a cell?
Describe the difference between cell formatting and cell style in Excel.
How can you apply a font style to multiple cells at once?
Explain how to apply bold, italic, and underline formatting to text in Excel.
Describe the process of applying borders and shading to cells in Excel.
What is the difference between a custom number format and a built-in number format?
What are the different types of number formats in Excel?
How can you adjust the alignment of text within a cell (e.g., left, right, center, top, bottom) in Excel?
How do you apply number formatting to display negative numbers in red or parentheses in Excel? ***
How can you format numbers to show a percentage sign?
How do you display currency symbols in a cell?
How do you display dates and times in a specific format?
How can you use the Format Painter tool to copy font formatting from one cell to another?
What are the different types of alignment options in Excel?
How can you wrap text in a cell?
How do you center text in a cell?
How do you center text horizontally and vertically in a cell?
What is the purpose of the “Merge & Center” command in Excel, and how does it affect the formatting of cells?
How can you add borders and shading to cells?
How can you quickly remove all formatting from a cell?
How can you change the horizontal and vertical alignment of a cell?
What are the different border styles available in Excel?
How do you add a border to a cell?
How do you change the border style and color?
How do you remove a border from a cell?
How do you add a background color to a cell?
What are cell styles?
Windows only
What is the keyboard shortcut for opening the Format Cells dialog box?
What is the keyboard shortcut for applying the Format Painter tool?
How can you rotate text?
What is the purpose of the Font dialog box?
How can you access the Format Cells dialog box in Excel to apply custom formatting?