Formatting Cells
Formatting changes how data looks without changing its actual value. This improves readability and presentation.
Number Formatting
Format numbers as Currency (₹, $), Percentages (%), Dates (DD-MM-YYYY), Time, or Scientific notation.
Text Formatting
Change Font, Size, Color, Bold, Italic, and Underline. Use Wrap Text to display long text on multiple lines within a single cell.
Alignment
Align text Left, Center, Right, Top, Middle, or Bottom. Merge & Center combines multiple cells into one large cell.
Paste Special
While standard Copy (Ctrl+C) and Paste (Ctrl+V) copy everything (formula, value, and format), Paste Special gives you control over what exactly gets pasted.
| Paste Special Option | Use Case |
|---|---|
| Values Only | Pastes only the result of a formula, removing the formula itself. |
| Formats Only | Pastes only the color, font, and borders (like the Format Painter). |
| Formulas Only | Pastes the formula but leaves the destination's formatting intact. |
| Transpose | Flips data from rows to columns, or columns to rows. |
Inserting and Deleting Rows/Columns
To insert a row, right-click a row number and select Insert (a new row appears above it). To insert a column, right-click a column letter and select Insert (a new column appears to the left). Deleting works similarly by selecting Delete from the right-click menu.