Insert a Check Mark in Excel
You can add check marks (β), crosses (β), or clickable checkboxes in Excel to create things like to-do lists or tracking sheets. 1. Insert a Check Mark Steps: β Result: A check mark appears π Make it nicer: 2. Insert a Cross (X) Steps: β Result: A cross (β) π You can color it Red
Superscript and Subscript in Excel
In Excel, you can format text as: π This is useful for math formulas, chemical formulas, and notes 1. Apply Superscript (xΒ²) Steps: Result: The number appears slightly above (xΒ²) 2. Apply Subscript (HβO) Steps: Result: The character appears slightly below (HβO) β οΈ Important Note π Example: 3. How to Calculate Powers To square a
Strikethrough in Excel
Strikethrough is a formatting style that draws a line through text.π Itβs useful for showing something is done, canceled, or no longer needed β while still keeping it visible. 1. Apply Strikethrough Steps: Result: Text now has a line through it 2. Use Keyboard Shortcut (Faster) Steps: Result: π Press Ctrl + 5 again to
Merge Cells in Excel
You can merge cells to create one larger cell.This is useful when you want a title or label across multiple columns. 1. Merge Cells (Basic Use) Steps: Result: β οΈ Important Warning If you merge cells with multiple values: π Example: 2. Unmerge Cells π Note: Deleted values will NOT come back unless you undo 3.
Wrap Text in Excel
When your text is too long for a cell, Excel can display it on multiple lines inside the same cell.This makes your data easier to read. 1. Wrap Text Automatically Excel can automatically move text to a new line. Steps: Result: 2. Adjust Column Width Sometimes you need more space: 3. Adjust Row Height To
Cell Styles in Excel
Cell Styles help you quickly format cells with just one click.Instead of changing font, color, borders one by one, you can apply a ready-made style instantly. 1. Apply a Built-in Cell Style Steps: Result: 2. Create Your Own Cell Style If the built-in styles are not enough, you can make your own. Steps: 3. Use
Format Painter in Excel
Format Painter is a very useful tool that helps youπ copy formatting from one cell and apply it to another This saves a lot of time because you donβt need to format each cell manually. What can Format Painter copy? It copies things like: How to Use Format Painter 1. Select the cell with the
Custom Number Format in excel
Excel already has many built-in formats like Currency, Date, Time, Percentage, etc.But sometimes, they donβt match what you need β thatβs when Custom Number Format is useful. 1. Leading Zeros Instead of typing extra zeros manually, let Excel do it for you. Steps: Result: 2. Decimal Places You can decide how many decimal places to
Conditional Formatting in Excel
Conditional formatting in Excel lets you automatically apply formatting (like colors or styles) to cells based on their values or specific conditions. You can use built-in rules or create custom formulas to control how cells are highlighted. Highlight Cells Rules To highlight cells that meet a specific condition, such as being greater than a certain