Ravindra BagaleCourses & study guides

1. Excel Basics

1.4 Formatting Cells

By Last updated:

Formatting changes how a cell looks, not its value.

Steps in Excel

  1. Font, fill, borders: Home › Font group (Bold Ctrl + B, Fill Color, Borders).
  2. Alignment: Home › Alignment – Wrap Text, Merge & Center, orientation, indent.
  3. Center Across Selection (better than Merge): select A1:F1 › Ctrl + 1 › Alignment tab › Horizontal › Center Across Selection.
  4. Cell Styles: Home › Styles › Cell Styles (Heading 1, Good, Bad, Neutral…).
  5. Format Painter: Home › Clipboard › Format Painter. Double-click it to paint many places; press Esc to stop.
  6. Clear formats only: Home › Editing › Clear › Clear Formats.
  7. Column width: double-click the boundary between column headers to AutoFit.

Worked example. Zoya formats the daily report header of the Hadapsar store: row 1 title "Blinkit Hadapsar – Daily Sales" in 14 pt bold, centred across A1:H1; header row 3 with dark green fill, white bold text and a bottom border; amounts right-aligned; AutoFit all columns.

Ravindra Bagale's Tip

Khup students heading sathi Merge & Center vapartat, aani mag sort, copy-paste aani filter la error yeto. Title sathi Center Across Selection vapra – disayla same, pan cells merge hot nahit. Data chya table madhe tar merge bilkul karu naka.

Practice task

Format your Orders sheet: bold header with fill colour, AutoFit widths, Center Across Selection for a title row, and apply the Heading 1 cell style to the title.