Excel Formatting Cells

Formatting in Excel refers to changing how a cell looks — such as the font, color, number style, and borders. Good formatting makes a spreadsheet easier to read and more professional. Formatting does not change the data inside a cell; it only changes the appearance.

Accessing Formatting Options

Most formatting tools are available on the Home tab in the Ribbon. There are also more detailed options available through the Format Cells dialog box, which can be opened by:

• Right-clicking a cell and selecting Format Cells, or
• Pressing Ctrl + 1 on the keyboard.

Font Formatting

Font formatting controls the appearance of the text inside cells.

Font Type

The default font in Excel is Calibri. A different font can be selected from the font dropdown in the Home tab. For example, choosing Arial or Times New Roman changes the style of text in the selected cell.

Font Size

Increase or decrease the size of text. Headings are usually set to a larger size (14–16pt) while regular data uses a smaller size (10–12pt).

Bold, Italic, Underline

• Bold (Ctrl + B): Makes text thicker and more prominent.
• Italic (Ctrl + I): Slants the text slightly.
• Underline (Ctrl + U): Draws a line beneath the text.

Font Color

The font color can be changed using the Font Color button on the Home tab. Click the dropdown arrow next to it to choose any color from the color palette.

Cell Fill Color (Background Color)

A background color can be applied to cells to highlight important rows or headings. Click the Fill Color button (paint bucket icon) on the Home tab and select a color.

Example

  Header row (Row 1): Apply yellow background to stand out
  Total row: Apply light blue background to distinguish totals

Alignment

Alignment controls how content is positioned inside a cell.

Horizontal Alignment

• Left Align: Content is pushed to the left (default for text).
• Center: Content is centered (useful for headings).
• Right Align: Content is pushed to the right (default for numbers).

Vertical Alignment

• Top Align: Content sits at the top of the cell.
• Middle Align: Content sits in the middle.
• Bottom Align: Content sits at the bottom (default).

Wrap Text

When a cell contains long text that extends beyond the cell border, Wrap Text breaks it into multiple lines within the same cell so it all becomes visible.

Click Wrap Text in the Home tab or press Alt + H + W.

Merge and Center

Merging combines multiple cells into one single cell. This is commonly used for titles that span across columns.

1. Select the range of cells to merge (e.g., A1:D1).
2. Click Merge and Center on the Home tab.

The content of the first cell will be centered across the merged area.

Number Formatting

Number formatting changes how numbers are displayed without changing the actual value stored in the cell.

Common Number Formats

• General: Default format. Displays numbers as entered.
• Number: Displays numbers with a set number of decimal places (e.g., 1000.00).
• Currency: Adds a currency symbol and two decimal places (e.g., $1,000.00).
• Accounting: Similar to Currency but aligns symbols and decimals in a column.
• Percentage: Multiplies the cell value by 100 and adds a % sign (e.g., 0.25 becomes 25%).
• Date: Displays the date in a chosen format (e.g., 01/15/2024 or 15-Jan-2024).
• Text: Treats the cell content as text, even if it is a number.

Example

  Cell value: 1500
  Format → Currency: $1,500.00
  Format → Percentage: 150000%  ← (because 1500 × 100)
  Format → Number (2 decimals): 1500.00

Increase or Decrease Decimal Places

Use the Increase Decimal and Decrease Decimal buttons in the Home tab to show more or fewer decimal places.

Borders

Borders are lines drawn around cells or ranges to visually separate sections of a spreadsheet. They make tables easier to read.

Applying Borders

1. Select the cells.
2. Click the Borders dropdown button on the Home tab (looks like a box with a grid).
3. Choose a border style: All Borders, Outside Borders, Bottom Border, etc.

Custom Borders

Go to Format Cells → Border tab to choose specific sides, line styles, and colors for borders.

Column Width and Row Height

Adjusting Column Width

• Hover over the right edge of a column header until a double arrow appears, then click and drag.
• Double-click the edge to AutoFit the column to the widest content.
• Right-click the column header → Column Width to enter a specific value.

Adjusting Row Height

• Hover over the bottom edge of a row header and drag to resize.
• Right-click the row header → Row Height to enter an exact value.

Format Painter

Format Painter copies the formatting from one cell and applies it to another cell or range — without copying the content.

1. Select the cell with the desired formatting.
2. Click the Format Painter button (paintbrush icon) on the Home tab.
3. Click or drag over the cells to apply the same formatting.

Double-clicking Format Painter locks it on so it can be applied to multiple areas before turning off (press Esc to stop).

Practical Example: Formatting a Simple Table

  Row 1 (Header row):
  - Bold the text in A1:C1
  - Apply a blue background fill
  - Change font color to white
  - Center-align the text

  Data rows (Row 2 and below):
  - Apply "All Borders" to the data range A1:C5
  - Format column C (prices) as Currency

  Total row (Row 6):
  - Bold the total values
  - Apply a light yellow background

Summary

• Formatting changes the appearance of cells without affecting the data.
• Font formatting includes font type, size, bold, italic, underline, and color.
• Alignment controls horizontal and vertical positioning of content within cells.
• Number formatting changes how numbers look (currency, percentage, decimal places, dates).
• Borders and fill colors make spreadsheets easier to read and more organized.
• Format Painter copies formatting from one cell to another quickly.