Superscript and Subscript in Excel

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 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

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

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

Format Painter in Excel

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

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

Convert Numbers to Text in Excel

Convert Text to Numbers in Excel

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

Convert Text to Numbers in Excel

Convert Text to Numbers in Excel

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

Currency vs Accounting in Excel

Currency vs Accounting in Excel

In Excel, Currency and Accounting formats are used to display money values.They look similar, but they behave slightly differently. 1. Apply Currency Format Step 1: Select the cells Select the range of cells that contains numbers. Step 2: Apply the format Go to: Home → Number group → Currency Shortcut: Ctrl + Shift + 4

Fractions in Excel

Fractions in Excel

Excel allows you to enter fractions, change fraction formats, and display fractions in different ways. 1. Enter a Fraction in Excel Mixed fraction To enter 1 4/7 (one and four sevenths) Simple fraction To enter 4/7, type: 0 4/7 The 0 is important, because without it Excel may think you are entering a date. Example: