Basic Cell Formatting: Fonts, Colors, Alignment & Borders

Why Formatting Matters

Imagine receiving two spreadsheets containing identical data. One is a wall of plain text with no visual distinction between headers and data, numbers and labels, important figures and supplementary information. The other has clear headers in bold, alternating row colors, properly aligned numbers, and borders separating different sections. Which would you rather work with?

Formatting is not just about making spreadsheets look pretty — it serves critical functional purposes that directly impact how effectively your data communicates information.

The Benefits of Good Formatting

Where Formatting is Applied

In Excel, formatting is applied to cells, not to the data itself. This means:

• The same cell can display the same number in different ways (1000 vs. $1,000.00 vs. 1,000)
• Formatting does not change the underlying value — only how it appears
• You can copy formatting separately from data
• Clearing formatting does not delete your data

The Format Cells Dialog Box

Excel provides multiple ways to format cells, but the most comprehensive is the Format Cells dialog box. This powerful tool gives you access to every formatting option in one place.

Opening the Format Cells Dialog

There are several ways to open this dialog:

1. Keyboard Shortcut (Fastest): Select cells and press Ctrl + 1
2. Right-Click Method: Select cells, right-click, and choose "Format Cells"
3. Ribbon Method: Home tab → click the small arrow in the bottom-right corner of the Font, Alignment, or Number group
4. Menu Method: Format menu → Cells (in older Excel versions)

The Six Tabs of Format Cells

Tab	What It Controls	Key Options
Number	How numbers are displayed	Currency, percentage, date formats, decimal places
Alignment	Position of content within cells	Horizontal/vertical alignment, text wrap, merge cells, text rotation
Font	Text appearance	Font family, size, color, bold, italic, underline, strikethrough
Border	Lines around cells	Line style, color, position (top, bottom, left, right, diagonal)
Fill	Cell background	Background color, pattern style, pattern color, gradient fills
Protection	Cell security settings	Locked, hidden (requires sheet protection to take effect)

Font Formatting

Font formatting controls how text appears in your cells — the typeface, size, color, and style. These options are found in the Font group on the Home tab, or in the Font tab of the Format Cells dialog.

Changing Font Family (Typeface)

The font family determines the overall look of your text. Excel comes with hundreds of fonts, but a few are most commonly used for spreadsheets:

How to Change Font Family

1. Select the cells you want to format
2. Go to Home tab → Font group
3. Click the Font dropdown (shows current font name)
4. Scroll through the list or type the font name to search
5. Click on a font to apply it

Changing Font Size

Font size is measured in points (pt). The default size in Excel is 11 points. Common sizes range from 8pt (very small) to 72pt (very large, typically for titles).

Size	Typical Use	Keyboard Shortcut
8-9 pt	Fine print, footnotes, dense data tables	—
10-11 pt	Standard body text, regular data	Default
12-14 pt	Slightly larger text, column headers	—
16-20 pt	Section headers, important labels	—
24+ pt	Main titles, presentation headers	—

Quick Size Adjustments

• Increase Font Size: Ctrl + Shift + >
• Decrease Font Size: Ctrl + Shift + <
• Or use the A buttons in the Font group (larger A increases, smaller A decreases)

Changing Font Color

Font color changes the color of the text itself (not the cell background). The Font Color button shows a colored underline indicating the currently selected color.

1. Select the cells
2. Click the dropdown arrow next to the Font Color button (A with colored underline)
3. Choose a color from the palette, or click "More Colors" for custom options

Font Styles: Bold, Italic, Underline

Font styles add emphasis to text. Excel provides three main styles that can be combined: Bold, Italic, and Underline.

Bold Text

Bold makes text heavier and darker, providing strong emphasis. It is perfect for headers, totals, important values, and labels.

Italic Text

Italic slants text to the right, providing subtle emphasis. It is often used for notes, references, or to distinguish certain types of content.

Underline Text

Underline adds a line beneath text. In spreadsheets, single underline is often used for subtotals, while double underline indicates grand totals (an accounting convention).

Combining Styles

You can apply multiple styles to the same text. For example, bold italic or bold underline. Simply apply each style one after another, or use the Format Cells dialog to set multiple options at once.

Strikethrough

Strikethrough draws a line through text, typically indicating deleted or completed items. There is no direct keyboard shortcut, but you can access it through Format Cells → Font tab → Effects section.

Cell Colors and Fill

Cell fill (also called background color or shading) adds color behind the text in a cell. This is one of the most effective ways to visually organize data and highlight important information.

Applying Fill Color

1. Select the cells you want to color
2. Find the Fill Color button on the Home tab (paint bucket icon)
3. Click the dropdown arrow to see the color palette
4. Choose a color — click once to apply
5. For more options, click "More Colors" for custom colors or Format Cells → Fill tab for patterns

Color Usage Guidelines

Color	Common Use	Example
Light Blue	Header rows, column titles	Table headers
Light Green	Positive values, completed items	Profit, success, approved
Light Red/Pink	Negative values, warnings, attention needed	Losses, errors, overdue
Light Yellow	Highlights, input cells, notes	Important data, user input areas
Light Gray	Alternating rows, secondary data	Banded rows for readability

Theme Colors vs. Standard Colors

Excel's color palette shows two sections:

• Theme Colors: Top section — these colors are tied to your workbook's theme and will change if you switch themes. They include variations (lighter/darker) of each theme color.
• Standard Colors: Bottom section — these are fixed colors that do not change with themes.

Pattern Fills

For more advanced effects, Excel supports pattern fills (stripes, dots, crosshatches). Access these through Format Cells → Fill tab → Pattern Style dropdown. Patterns are rarely used in modern spreadsheets but can be useful for distinguishing areas when printing in black and white.

Text Alignment

Alignment controls where content is positioned within a cell. Proper alignment significantly improves readability, especially in tables with mixed data types.

Horizontal Alignment

Horizontal alignment positions content left-to-right within the cell:

Alignment	Best For	Shortcut
Left	Text, names, descriptions, labels	Ctrl + L
Center	Headers, titles, short labels, categories	Ctrl + E
Right	Numbers, currencies, quantities, dates	Ctrl + R

Vertical Alignment

Vertical alignment positions content top-to-bottom within the cell (most noticeable when row height is larger than the text):

• Top: Content aligns to the top of the cell
• Middle (Center): Content is centered vertically — the default
• Bottom: Content aligns to the bottom of the cell

Text Wrap

When text is longer than the column width, you have several options:

• Overflow: Text extends into adjacent empty cells (default behavior)
• Truncate: Text is cut off at the cell border (if adjacent cell has data)
• Wrap Text: Text wraps to multiple lines within the cell, increasing row height

To enable text wrap: Home tab → Alignment group → click Wrap Text button

Indent

Indenting moves content inward from the cell edge, useful for creating visual hierarchy in lists or categories:

• Increase Indent: Home → Alignment → Increase Indent button
• Decrease Indent: Home → Alignment → Decrease Indent button

Text Orientation (Rotation)

You can rotate text at an angle, which is useful for narrow column headers:

1. Select the cells
2. Home tab → Alignment group → Orientation button (angled "ab")
3. Choose from preset angles or "Format Cell Alignment" for custom degrees

Cell Borders

Borders add lines around cells to define boundaries, separate sections, and create visual structure. The faint gridlines you see on screen are not borders — they are just visual guides that do not print by default.

Border Examples

Applying Borders

1. Select the cells where you want borders
2. Go to Home tab → Font group → Borders button (grid icon with dropdown)
3. Click the dropdown arrow to see border options
4. Choose a preset: Bottom Border, All Borders, Outside Borders, etc.
5. For custom borders, choose "More Borders" to access the Format Cells Border tab

Common Border Presets

Preset	Description	Best Use
Bottom Border	Line under selected cells only	Separating headers from data, subtotals
Top and Bottom Border	Lines above and below	Highlighting a row
All Borders	Grid lines around every cell	Complete tables, forms
Outside Borders	Box around the selection only	Grouping related cells, sections
Thick Box Border	Heavy border around selection	Emphasizing important areas
Top and Thick Bottom	Thin top, heavy bottom	Totals row (accounting style)

Custom Borders (Format Cells → Border Tab)

The Border tab in Format Cells gives you full control:

• Line Style: Thin, thick, dashed, dotted, double, etc.
• Line Color: Any color from the palette
• Position: Click on specific edges (top, bottom, left, right) or use presets
• Diagonal Lines: Add diagonal lines through cells

Merging Cells

Merging combines multiple cells into one larger cell. This is commonly used for titles that span multiple columns or for creating visual groupings.

How to Merge Cells

1. Select the cells you want to merge
2. Go to Home tab → Alignment group
3. Click the Merge & Center dropdown
4. Choose an option:
   • Merge & Center: Combines cells and centers content (most common)
   • Merge Across: Merges cells in each row separately
   • Merge Cells: Combines cells without centering
   • Unmerge Cells: Splits merged cells back to individual cells

Alternative: Center Across Selection

If you just want to center a title across multiple columns without actually merging cells, use "Center Across Selection":

1. Type your title in the leftmost cell
2. Select that cell and the cells to its right that you want to span
3. Open Format Cells (Ctrl + 1) → Alignment tab
4. Under Horizontal, choose "Center Across Selection"
5. Click OK

This centers the text visually but keeps cells separate — avoiding merge-related problems.

Format Painter

The Format Painter is one of Excel's most useful tools for formatting. It copies the formatting from one cell and applies it to others — instantly transferring fonts, colors, borders, alignment, and number formats.

Using Format Painter (Single Use)

1. Select a cell that has the formatting you want to copy
2. Click the Format Painter button (paintbrush icon) on the Home tab
3. Your cursor changes to a paintbrush icon
4. Click or drag over the cells where you want to apply the formatting
5. Formatting is applied and Format Painter turns off automatically

Using Format Painter (Multiple Uses)

To apply the same formatting to multiple non-adjacent areas:

1. Select the cell with source formatting
2. Double-click the Format Painter button (this locks it on)
3. Click or drag over the first destination area
4. Click or drag over additional areas — Format Painter stays active
5. Press Escape or click Format Painter again when finished

Format Painter Keyboard Shortcut

While there is no single keyboard shortcut for Format Painter, you can use these combinations:

• Copy formatting: Ctrl + Shift + C
• Paste formatting: Ctrl + Shift + V

Cell Styles

Cell Styles are predefined formatting combinations that you can apply with one click. Excel includes built-in styles for common formatting needs, and you can create custom styles for your own preferences.

Applying Cell Styles

1. Select the cells to format
2. Go to Home tab → Styles group
3. Click Cell Styles to open the gallery
4. Hover over styles to preview them on your selection
5. Click a style to apply it

Built-in Style Categories

Category	Includes	Use For
Good, Bad, Neutral	Green (Good), Red (Bad), Yellow (Neutral)	Highlighting performance, status indicators
Data and Model	Calculation, Check Cell, Input, Output, etc.	Financial models, distinguishing cell types
Titles and Headings	Heading 1-4, Title, Total	Document structure, hierarchy
Themed Cell Styles	Various accent colors with intensity levels	Color-coding, visual organization
Number Format	Comma, Currency, Percent	Quick number formatting

Creating Custom Cell Styles

1. Format a cell exactly how you want the style to look
2. With that cell selected, go to Home → Cell Styles → New Cell Style
3. Give your style a name (e.g., "Company Header")
4. Choose which formatting attributes to include
5. Click OK — your style is now available in the Cell Styles gallery

Clearing Formatting

Sometimes you need to remove formatting and start fresh. Excel provides several options for clearing different types of content.

Clear Options

Go to Home tab → Editing group → Clear dropdown:

Option	What It Removes	What It Keeps
Clear All	Everything — content, formatting, comments	Nothing
Clear Formats	All formatting only	Content (data, formulas)
Clear Contents	Content (data, formulas) only	Formatting
Clear Comments	Comments and notes only	Content and formatting
Clear Hyperlinks	Hyperlinks only	Text and formatting

Quick Clear Shortcuts

• Delete key: Clears contents only (keeps formatting)
• Backspace: Clears contents and enters edit mode
• Clear Formats: No direct shortcut — use the menu

Formatting Best Practices

Good formatting improves readability without overwhelming the data. Here are professional guidelines:

General Guidelines

• Less is more: Do not over-format. Simple, clean formatting is more professional than rainbow colors and excessive borders.
• Be consistent: Use the same formatting for similar elements throughout your workbook.
• Use a maximum of 3 fonts: Typically one for titles, one for headers, one for body text.
• Limit your color palette: Stick to 3-5 colors that work well together.
• Format for purpose: Consider whether the sheet will be viewed on screen, printed, or presented.

Specific Recommendations

Element	Recommended Formatting
Main Title	Large (16-20pt), Bold, possibly merged across columns
Column Headers	Bold, centered, light fill color, bottom border
Data Rows	Standard size (10-11pt), alternating row colors optional
Totals Row	Bold, top border (thin), bottom border (double)
Numbers	Right-aligned, consistent decimal places
Text	Left-aligned
Negative Numbers	Red color and/or parentheses

Practice Exercise: Format a Sales Report

Apply everything you have learned by formatting a complete sales report from scratch.