Learn essential Excel skills such as entering data, formatting cells, using AutoFill, and working with simple formulas through clear, practical examples.
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
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 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
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.
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 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 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
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
In Excel: Sometimes, you may want numbers to behave like text (for IDs, phone numbers, etc.). 1. Change Number Format to Text Now, anything you type will be treated as text (even numbers) 2. Add an Apostrophe Excel will treat it as text, but the apostrophe won’t show in the cell 3. Use the TEXT
In Excel, text is left-aligned and numbers are right-aligned. This example teaches you how to convert ‘text strings that represent numbers’ to numbers. 1. Select the range A1:A4 and change the number format to General. 2. Numbers preceded by an apostrophe are also treated as text. Select cell A5 and manually remove the apostrophe. 3a. You can also combine